eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on JA_CN_CODE_COMBINATION_V

Line 743: Ja_Cn_Code_Combination_v Jcc,

739: CURSOR prepaid_account_num_cur IS
740: SELECT DISTINCT Jcc.account_segment Prepaid_Account_Num
741: FROM Ap_Invoices_All Aia,
742: Xla_Transaction_Entities Ent,
743: Ja_Cn_Code_Combination_v Jcc,
744: Xla_Ae_Headers Aeh,
745: Xla_Ae_Lines Ael
746: WHERE Ent.Application_Id = 200
747: AND Aia.Invoice_Id = Ent.Source_Id_Int_1

Line 1053: Ja_Cn_Code_Combination_v Jcc

1049: SELECT SUM(NVL(Ael.Accounted_Dr, 0) + -1 * NVL(Ael.Accounted_Cr, 0)) Functional_Amount,
1050: SUM(NVL(Ael.Entered_Dr, 0) + -1 * NVL(Ael.Entered_Cr, 0)) Entered_Amount
1051: FROM Xla_Ae_Lines Ael,
1052: Xla_Ae_Headers Aeh,
1053: Ja_Cn_Code_Combination_v Jcc
1054: WHERE Ael.Ae_Header_Id = Aeh.Ae_Header_Id
1055: AND Ael.Accounting_Class_Code <> 'LIABILITY'
1056: AND Aeh.Ae_Header_Id = pn_ae_header_id --parameter: pn_ae_header_id
1057: AND Jcc.Code_Combination_Id = Ael.Code_Combination_Id

Line 1897: Ja_Cn_Code_Combination_v Jcc

1893: FROM Ap_Invoices_All Aia,
1894: Xla_Transaction_Entities Ent,
1895: Xla_Ae_Headers Aeh,
1896: Xla_Ae_Lines Ael,
1897: Ja_Cn_Code_Combination_v Jcc
1898: WHERE Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id
1899: AND Aia.Invoice_Type_Lookup_Code = 'PREPAYMENT'
1900: --SLA condition
1901: AND Ent.Application_Id = 200

Line 1927: Ja_Cn_Code_Combination_v Jcc,

1923: SELECT SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Applied_Amount
1924: FROM Ap_Prepay_History_All Aph,
1925: Xla_Ae_Headers Aeh,
1926: Xla_Ae_Lines Ael,
1927: Ja_Cn_Code_Combination_v Jcc,
1928: Gl_Je_Headers Jeh,
1929: Gl_Import_References Gir
1930: WHERE Aph.Prepay_Invoice_Id = pn_invoice_id --parameter: pn_invoice_id
1931: AND Aph.Accounting_Event_Id = Aeh.Event_Id

Line 2037: Ja_Cn_Code_Combination_v Jcc,

2033: SELECT DISTINCT Account_Number
2034: FROM (SELECT Jab.Account_Segment Account_Number
2035: FROM Xla_Ae_Headers Aeh,
2036: Xla_Ae_Lines Ael,
2037: Ja_Cn_Code_Combination_v Jcc,
2038: Ja_Cn_Account_Balances Jab
2039: WHERE Jab.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2040: AND Jab.Legal_Entity_Id = pn_legal_entity_id --parameter: pn_legal_entity_id
2041: AND Jab.Period_Name = pv_first_period --parameter: pv_first_period

Line 2246: Ja_Cn_Code_Combination_v Jcc,

2242: SELECT DECODE(COUNT(*), 0, 'Y', 'N') no_trans_flag
2243: FROM Gl_Je_Lines Jel,
2244: Gl_Je_Headers Jeh,
2245: Gl_Import_References Gir,
2246: Ja_Cn_Code_Combination_v Jcc,
2247: Gl_Ledgers Gl,
2248: Gl_Periods Gp,
2249: Xla_Ae_Lines Ael,
2250: Xla_Ae_Headers Aeh,

Line 2655: Ja_Cn_Code_Combination_v Jcc,

2651: Fcv.Name Functional_Currency
2652: FROM Gl_Je_Lines Jel,
2653: Gl_Je_Headers Jeh,
2654: Gl_Import_References Gir,
2655: Ja_Cn_Code_Combination_v Jcc,
2656: Gl_Ledgers Gl,
2657: Gl_Periods Gp,
2658: Xla_Ae_Lines Ael,
2659: Xla_Ae_Headers Aeh,

Line 3020: FROM Ja_Cn_Code_Combination_v Jcc,

3016:
3017: --Cursor for fetching prepaid account number
3018: CURSOR prepaid_account_num_cur(ln_ae_header_id NUMBER) IS
3019: SELECT DISTINCT Jcc.account_segment Prepaid_Account_Num
3020: FROM Ja_Cn_Code_Combination_v Jcc,
3021: Xla_Ae_Headers Aeh,
3022: Xla_Ae_Lines Ael
3023: WHERE Ael.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
3024: AND Ael.Ae_Header_Id = Aeh.Ae_Header_Id