Oracle ERP World

Security Rule allows restricting user access to various key flexfield segments list of value. 1. Enable security on the value  set.To  en...

This is how the accounting works. Everything pertains to what an Organization owns, have and what it has to give. There is always a balance...

--ORDER MAIN TABLES select flow_status_code, booked_flag, a.* from oe_order_headers_all a where order_number = '4025794'; select f...

--Create Function CREATE OR REPLACE FUNCTION APPS.XXX_CREATE_CCID ( P_CONCAT_SEGS IN VARCHAR2 ) RETURN VARCHAR2 IS L_STATUS BOOLEAN; L_COA_...

SELECT GLV.LEDGER_CATEGORY_CODE,        GLV.NAME,        GLV.SHORT_NAME,        GLV.DESCRIPTION,        GLV.CHART_OF_ACCOUNTS_ID,     ...

-- Function and procedure implementations FUNCTION To_Get_Account_Desc ( I_LEDGER_ID IN NUMBER , I_...

Interface tables: GL_INTERFACE Base tables: GL_JE_HEADERS GL_JE_LINES GL_JE_BACTHES Concurrent Program:   Journal Import Jou...