APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on JA_CN_CODE_COMBINATION_V

Line 434: -- into view JA_CN_CODE_COMBINATION_V

430: --
431: -- DESCRIPTION:
432: -- This procedure is used to populate account segment, company segment
433: -- cost center segment and project number if project option as 'COA'
434: -- into view JA_CN_CODE_COMBINATION_V
435: -- PARAMETERS:
436: --
437: --
438: --

Line 616: l_Create_View_Sql := 'create or replace view ja_cn_code_combination_v as ' ||

612: 'to_number(null) project_id from gl_code_combinations gcc,' ||
613: ' GL_LEDGERS led where led.chart_of_accounts_id ' ||
614: ' = gcc.chart_of_accounts_id';
615:
616: l_Create_View_Sql := 'create or replace view ja_cn_code_combination_v as ' ||
617: l_Create_View_Sql;
618:
619: --log for debug
620: IF (l_Proc_Level >= l_Dbg_Level) THEN

Line 978: Ja_Cn_Code_Combination_v Jcc,

974: -- To_Number(NULL),
975: -- Jeh.Last_Updated_By)
976: FROM Gl_Je_Headers Jeh,
977: Gl_Je_Lines Jel,
978: Ja_Cn_Code_Combination_v Jcc,
979: Ja_Cn_Journals_Of_Period Jop,
980: Gl_Je_Batches Jeb--added by lyb, for bug 6654734
981: WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id
982: AND Jcc.Ledger_Id = Jeh.Ledger_Id

Line 1307: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';

1303: l_sql:=l_sql||' Gl_Je_Batches Jeb,';
1304: l_sql:=l_sql||' Xla_Ae_Lines Ael,';
1305: l_sql:=l_sql||' Xla_Ae_Headers Aeh,';
1306: l_sql:=l_sql||' Gl_Import_References Gir,';
1307: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';
1308: l_sql:=l_sql||' xla_ae_line_acs acs,';
1309: l_sql:=l_sql||' ap_suppliers sup,';
1310: l_sql:=l_sql||' Ja_Cn_Journals_Of_Period Jop,';
1311: l_sql:=l_sql||' Hz_Cust_Accounts Cust,';

Line 1448: ,Ja_Cn_Code_Combination_v Jcc

1444: ,Gl_Je_Batches Jeb --added by lyb, for bug 6654734
1445: ,Xla_Ae_Lines Ael
1446: ,Xla_Ae_Headers Aeh
1447: ,Gl_Import_References Gir
1448: ,Ja_Cn_Code_Combination_v Jcc
1449: ,Ap_Suppliers Sup
1450: ,
1451: -- per_all_people_f per,
1452: Ja_Cn_Journals_Of_Period Jop