APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on GL_JE_LINES

Line 388: ' ,gl_je_lines jel' ||

384: ' ,bsv.legal_entity_id' || ',' ||
385: l_Request_Id ||
386: ',jeh.default_effective_date ' ||
387: ' FROM gl_je_headers jeh' ||
388: ' ,gl_je_lines jel' ||
389: ' ,gl_code_combinations gcc' ||
390: ' ,gl_periods gp' ||
391: ' ,gl_ledgers led' ||
392: ' ,ja_cn_ledger_le_bsv_gt bsv' ||

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

853: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
854: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
855: l_Proc_Name VARCHAR2(100) := 'purge_unmatch_lines';
856: CURSOR c_Unmatch_Lines IS
857: SELECT /*+ index(jel,gl_je_lines_u1)*/
858: Req.Je_Header_Id, Req.Je_Line_Num
859: FROM (SELECT SUM(Nvl(Req.Accounted_Dr, 0) - Nvl(Req.Accounted_Cr, 0)) Accounted_Amount,
860: SUM(Nvl(Req.Entered_Dr, 0) - Nvl(Req.Entered_Cr, 0)) Entered_Amount,
861: Req.Je_Header_Id,

Line 866: Gl_Je_Lines Jel

862: Req.Je_Line_Num
863: FROM Ja_Cn_Journal_Lines_Req Req
864: WHERE Req.Request_Id = l_Request_Id
865: GROUP BY Req.Je_Header_Id, Req.Je_Line_Num) Req,
866: Gl_Je_Lines Jel
867: WHERE (Nvl(Jel.Accounted_Dr, 0) - Nvl(Jel.Accounted_Cr, 0) <>
868: Req.Accounted_Amount OR
869: Nvl(Jel.Entered_Dr, 0) - Nvl(Jel.Entered_Cr, 0) <>
870: Req.Entered_Amount)

Line 1138: l_sql:=l_sql||' Gl_Je_Lines Jel,';

1134: l_sql:=l_sql||' Jeh.Created_By,';
1135: l_sql:=l_sql||' Jeb.Posted_By, ';
1136: l_sql:=l_sql|| l_SM_Query_Header_Sql; -- Added for fetching settlement method
1137: l_sql:=l_sql||' FROM Gl_Je_Headers Jeh,';
1138: l_sql:=l_sql||' Gl_Je_Lines Jel,';
1139: l_sql:=l_sql||' Ja_Cn_Code_Combination_v Jcc,';
1140: l_sql:=l_sql||' Ja_Cn_Journals_Of_Period Jop,';
1141: l_sql:=l_sql||' Gl_Je_Batches Jeb ';
1142: l_sql:=l_sql||' WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id';

Line 1239: Gl_Je_Lines Jel,

1235: -- 'R',
1236: -- To_Number(NULL),
1237: -- Jeh.Last_Updated_By)
1238: FROM Gl_Je_Headers Jeh,
1239: Gl_Je_Lines Jel,
1240: Ja_Cn_Code_Combination_v Jcc,
1241: Ja_Cn_Journals_Of_Period Jop,
1242: Gl_Je_Batches Jeb--added by lyb, for bug 6654734
1243: WHERE Jeh.Je_Header_Id = Jel.Je_Header_Id

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

1708: -- l_sql:='';
1709:
1710: l_sql:=l_sql||' To_Number(NULL),';
1711: l_sql:=l_sql||' Jeh.Last_Updated_By)';*/
1712: l_sql:=l_sql||' FROM Gl_Je_Lines Jel,';
1713: l_sql:=l_sql||' Gl_Je_Headers Jeh,';
1714: l_sql:=l_sql||' Gl_Je_Batches Jeb,';
1715: l_sql:=l_sql||' Xla_Ae_Lines Ael,';
1716: l_sql:=l_sql||' Xla_Ae_Headers Aeh,';

Line 1857: FROM Gl_Je_Lines Jel

1853: -- 'N'),
1854: -- 'R',
1855: -- To_Number(NULL),
1856: -- Jeh.Last_Updated_By)
1857: FROM Gl_Je_Lines Jel
1858: ,Gl_Je_Headers Jeh
1859: ,Gl_Je_Batches Jeb --added by lyb, for bug 6654734
1860: ,Xla_Ae_Lines Ael
1861: ,Xla_Ae_Headers Aeh

Line 2132: UPDATE Gl_Je_Lines Jel

2128: AND REQ.JE_HEADER_ID > 0;
2129: COMMIT;
2130:
2131: --update journal line into status of itemizated
2132: UPDATE Gl_Je_Lines Jel
2133: SET Jel.Global_Attribute7 = 'P' --Updated for CNAOV2 solution by chaoqun on 13-May-2010
2134: WHERE Jel.Je_Line_Num IN
2135: (SELECT Je_Line_Num
2136: FROM Ja_Cn_Journals_Of_Period