APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on XLA_AE_LINES

Line 1241: l_sql:=l_sql||' SELECT /*+index(ael,xla_ae_lines_n4)+*/';

1237: --for test
1238: -- l_sql:='';
1239: l_sql:=l_sql||' Journal_Created_By,';
1240: l_sql:=l_sql||' Journal_Posted_By)';
1241: l_sql:=l_sql||' SELECT /*+index(ael,xla_ae_lines_n4)+*/';
1242: l_sql:=l_sql||' Jel.Je_Header_Id Je_Header_Id,';
1243: l_sql:=l_sql||' Jeh.Ledger_Id Ledger_Id,';
1244: l_sql:=l_sql||' Jop.Legal_Entity_Id Legal_Entity_Id,';
1245: l_sql:=l_sql||' To_Number(NULL) Journal_Number,';

Line 1304: l_sql:=l_sql||' Xla_Ae_Lines Ael,';

1300: l_sql:=l_sql||' Jeh.Last_Updated_By)';*/
1301: l_sql:=l_sql||' FROM Gl_Je_Lines Jel,';
1302: l_sql:=l_sql||' Gl_Je_Headers Jeh,';
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,';

Line 1374: SELECT /*+index(ael,xla_ae_lines_n4)+*/

1370: Populate_Code,
1371: Request_Id,
1372: Journal_Created_By,
1373: Journal_Posted_By)
1374: SELECT /*+index(ael,xla_ae_lines_n4)+*/
1375: Jel.Je_Header_Id Je_Header_Id
1376: ,Jeh.Ledger_Id Ledger_Id
1377: ,Jop.Legal_Entity_Id Legal_Entity_Id
1378: ,To_Number(NULL) Journal_Number

Line 1445: ,Xla_Ae_Lines Ael

1441: -- Jeh.Last_Updated_By)
1442: FROM Gl_Je_Lines Jel
1443: ,Gl_Je_Headers Jeh
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