DBA Data[Home] [Help]

APPS.JA_CN_COA_EXPORT_PKG dependencies on JA_CN_ACC_SUBS_V

Line 32: -- Balance Side of all accounts INTO view 'JA_CN_ACC_SUBS_V'.

28: --
29: -- DESCRIPTION:
30: -- This procedure gets account number, level, subsidiary account flag,
31: -- and item of project, third party, cost center and personnel, and
32: -- Balance Side of all accounts INTO view 'JA_CN_ACC_SUBS_V'.
33: --
34: -- PARAMETERS:
35: -- In: P_LEDGER_ID NUMBER ID of Ledger
36: -- In: P_COA_ID NUMBER chart of accounts ID

Line 161: l_sql_str := 'CREATE OR REPLACE VIEW JA_CN_ACC_SUBS_V AS ' ||

157: ;
158: END IF;
159:
160:
161: l_sql_str := 'CREATE OR REPLACE VIEW JA_CN_ACC_SUBS_V AS ' ||
162: l_sql_str;
163: EXECUTE IMMEDIATE l_sql_str;
164:
165: End Get_Acc_Subs_View;

Line 310: FROM JA_CN_ACC_SUBS_V sub

306: ), 'Cost Center', l_costcenter_meaning
307: ), 'Personnel', l_personnel_meaning
308: ) sub_item
309: ,nvl(sub.acc_bal, '') acc_bal
310: FROM JA_CN_ACC_SUBS_V sub
311: ,FND_ID_FLEX_SEGMENTS FIFS
312: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
313: ,FND_FLEX_VALUE_SETS FFVS
314: ,FND_FLEX_VALUES FFV