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 AP_INVOICE_PAYMENTS_ALL

Line 983: FROM Ap_Invoice_Payments_All Aip

979: --Cursor for fetching invoice amount or payment amount at SLA level
980: CURSOR amount_cur IS
981: SELECT -1 * NVL(Aip.Amount, 0) Entered_Amount,
982: -1 * NVL(Aip.Payment_Base_Amount, NVL(Aip.Amount, 0)) Functional_Amount
983: FROM Ap_Invoice_Payments_All Aip
984: WHERE Aip.Invoice_Payment_Id = pn_invoice_payment_id; -- parameter: pn_invoice_payment_id
985:
986: BEGIN
987: --logging for debug

Line 1593: FROM Ap_Invoice_Payments_All aipa

1589: --To handle schedule payment
1590: OR
1591: (pn_inovice_payment_id IS NOT NULL AND EXISTS
1592: (SELECT aipa.Payment_Num
1593: FROM Ap_Invoice_Payments_All aipa
1594: WHERE aipa.Invoice_Id = apsa.Invoice_Id
1595: AND aipa.Payment_Num = apsa.Payment_Num
1596: AND aipa.Invoice_Payment_id = pn_inovice_payment_id))) --parameter: pn_inovice_payment_id
1597: ORDER BY Due_Date;

Line 1698: Ap_Invoice_Payments_All Aip,

1694: 0) + -1 * NVL(Ael.Entered_Cr,
1695: 0)) Paid_Amount
1696: FROM Ap_Invoices_All Aia,
1697: Ap_Checks_All Ach,
1698: Ap_Invoice_Payments_All Aip,
1699: Xla_Transaction_Entities Ent,
1700: Xla_Ae_Headers Aeh,
1701: Xla_Ae_Lines Ael,
1702: Gl_Je_Headers Jeh,

Line 1734: FROM Ap_Invoices_All Aia, Ap_Invoice_Payments_All Aip

1730: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1731: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1732: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id*/
1733: SELECT SUM(NVL(Aip.Amount, 0)) Paid_Amount
1734: FROM Ap_Invoices_All Aia, Ap_Invoice_Payments_All Aip
1735: WHERE Aia.Invoice_Id = Aip.Invoice_Id
1736: AND Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id
1737: AND EXISTS
1738: (SELECT Ach.Check_Id

Line 2445: from AP_INVOICE_PAYMENTS_ALL aip

2441: p_ae_header_id number,p_invoice_payment_id number) return boolean
2442: is
2443: cursor cur_invoice is
2444: select trunc(accounting_date, 'mm') accounting_date
2445: from AP_INVOICE_PAYMENTS_ALL aip
2446: where aip.check_id = p_check_id;
2447: l_void_date date;
2448: l_invoice_status varchar2(30);
2449: l_enent_type_code varchar2(50);

Line 2719: Ap_Invoice_Payments_All Aip,

2715: UNION
2716: SELECT Aia.Invoice_Id Invoice_Id
2717: FROM Ap_Invoices_All Aia,
2718: Ap_Checks_All Ach,
2719: Ap_Invoice_Payments_All Aip,
2720: Xla_Transaction_Entities Ent,
2721: Xla_Ae_Headers Aeh
2722: WHERE Ent.Application_Id = 200
2723: AND Aia.Invoice_Id = Aip.Invoice_Id

Line 2753: FROM Ap_Invoices_All Aia, Ap_Invoice_Payments_All Aip

2749: FROM (SELECT lv_inv_period_name Period_Name
2750: FROM dual
2751: UNION
2752: SELECT DISTINCT Aip.Period_Name
2753: FROM Ap_Invoices_All Aia, Ap_Invoice_Payments_All Aip
2754: WHERE Aia.Invoice_Id = Aip.Invoice_Id
2755: AND Aia.Invoice_Id = ln_invoice_id --variable: ln_invoice_id
2756: ) Ppn --period name for payables
2757: ,

Line 2889: Ap_Invoice_Payments_All Aip,

2885: '' Clear_Flag,
2886: '' Remittance_Bill_Number
2887: FROM Ap_Invoices_All Aia,
2888: Ap_Checks_All Ach,
2889: Ap_Invoice_Payments_All Aip,
2890: Xla_Transaction_Entities Ent,
2891: Xla_Ae_Headers Aeh,
2892: Xla_Ae_Lines Ael,
2893: Gl_Je_Headers Jeh,