APPS.JA_CN_COA_EXP_PKG dependencies on JA_CN_ACC_SUBS_V

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

75: --
76: -- DESCRIPTION:
77: -- This procedure gets account number, level, subsidiary account flag,
78: -- and item of project, third party, cost center and personnel, and
79: -- Balance Side of all accounts INTO view 'JA_CN_ACC_SUBS_V'.
80: --
81: -- PARAMETERS:
82: -- In: P_LEDGER_ID NUMBER ID of Ledger
83: -- In: P_COA_ID NUMBER chart of accounts ID

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

245: ;
246: END IF;
247:
248:
249: l_sql_str := 'CREATE OR REPLACE VIEW JA_CN_ACC_SUBS_V AS ' ||
250: l_sql_str;
251:
252: /* l_sql :=
253: 'SELECT DISTINCT ' --For porject of 'N' or 'COA'

Line 390: l_sql := 'CREATE OR REPLACE VIEW JA_CN_ACC_SUBS_V AS ' ||

386: ||' AND nvl(SOB.GLOBAL_ATTRIBUTE1, ''N'') = ''PA'' '
387: ||' AND BAL.account_segment(+) = FFV.FLEX_VALUE '
388: ;
389:
390: l_sql := 'CREATE OR REPLACE VIEW JA_CN_ACC_SUBS_V AS ' ||
391: l_sql;*/
392:
393: --dbms_output.put_line(l_sql);
394: EXECUTE IMMEDIATE l_sql_str;

Line 561: FROM JA_CN_ACC_SUBS_V sub

557: ), 'Cost Center', l_costcenter_meaning
558: ), 'Personnel', l_personnel_meaning
559: ) sub_item
560: ,nvl(sub.acc_bal, '') acc_bal
561: FROM JA_CN_ACC_SUBS_V sub
562: ,FND_ID_FLEX_SEGMENTS FIFS
563: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
564: ,FND_FLEX_VALUE_SETS FFVS
565: ,FND_FLEX_VALUES FFV