APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on GL_JE_LINES

Line 368: ' ,gl_je_lines jel' ||

364: ' ,bsv.legal_entity_id' || ',' ||
365: l_Request_Id ||
366: ',jeh.default_effective_date ' ||
367: ' FROM gl_je_headers jeh' ||
368: ' ,gl_je_lines jel' ||
369: ' ,gl_code_combinations gcc' ||
370: ' ,gl_periods gp' ||
371: ' ,gl_ledgers led' ||
372: ' ,ja_cn_ledger_le_bsv_gt bsv' ||

Line 771: SELECT /*+ index(jel,gl_je_lines_u1)*/

767: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
768: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
769: l_Proc_Name VARCHAR2(100) := 'purge_unmatch_lines';
770: CURSOR c_Unmatch_Lines IS
771: SELECT /*+ index(jel,gl_je_lines_u1)*/
772: Req.Je_Header_Id, Req.Je_Line_Num
773: FROM (SELECT SUM(Nvl(Req.Accounted_Dr, 0) - Nvl(Req.Accounted_Cr, 0)) Accounted_Amount,
774: SUM(Nvl(Req.Entered_Dr, 0) - Nvl(Req.Entered_Cr, 0)) Entered_Amount,
775: Req.Je_Header_Id,

Line 780: Gl_Je_Lines Jel

776: Req.Je_Line_Num
777: FROM Ja_Cn_Journal_Lines_Req Req
778: WHERE Req.Request_Id = l_Request_Id
779: GROUP BY Req.Je_Header_Id, Req.Je_Line_Num) Req,
780: Gl_Je_Lines Jel
781: WHERE (Nvl(Jel.Accounted_Dr, 0) - Nvl(Jel.Accounted_Cr, 0) <>
782: Req.Accounted_Amount OR
783: Nvl(Jel.Entered_Dr, 0) - Nvl(Jel.Entered_Cr, 0) <>
784: Req.Entered_Amount)

Line 977: Gl_Je_Lines Jel,

973: -- 'R',
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

Line 1301: l_sql:=l_sql||' FROM Gl_Je_Lines Jel,';

1297: -- l_sql:='';
1298:
1299: l_sql:=l_sql||' To_Number(NULL),';
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,';

Line 1442: FROM Gl_Je_Lines Jel

1438: -- 'N'),
1439: -- 'R',
1440: -- To_Number(NULL),
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

Line 1689: UPDATE Gl_Je_Lines Jel

1685: AND REQ.JE_HEADER_ID > 0;
1686: COMMIT;
1687:
1688: --update journal line into status of itemizated
1689: UPDATE Gl_Je_Lines Jel
1690: SET Jel.Global_Attribute2 = 'P'
1691: WHERE Jel.Je_Line_Num IN
1692: (SELECT Je_Line_Num
1693: FROM Ja_Cn_Journals_Of_Period