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.

[Home] [Help]

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on AP_INVOICES_ALL

Line 607: FROM HZ_CUST_ACCOUNTS cust, HZ_PARTIES part, AP_INVOICES_ALL aia

603: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
604:
605: CURSOR customer_num_cur IS
606: SELECT DISTINCT part.party_number Customer_Number
607: FROM HZ_CUST_ACCOUNTS cust, HZ_PARTIES part, AP_INVOICES_ALL aia
608: WHERE cust.cust_account_id = aia.party_id
609: AND cust.party_id = part.party_id
610: AND aia.Invoice_Id = pn_invoice_id; --parameter: pn_invoice_id
611:

Line 741: FROM Ap_Invoices_All Aia,

737: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
738:
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

Line 903: FROM Ap_Invoices_All Aia1,

899: AND Aeh1.Ae_Header_Id = pn_ae_header_id --parameter: pn_ae_header_id
900: AND Aeh1.Ledger_Id = pn_ledger_id), --parameter: pn_ledger_id
901: 0,
902: (SELECT MIN(Aeh1.Ae_Header_Id)
903: FROM Ap_Invoices_All Aia1,
904: Xla_Transaction_Entities Ent1,
905: Xla_Ae_Headers Aeh1
906: WHERE Ent1.Application_Id = 200
907: AND Aia1.Invoice_Id = Ent1.Source_Id_Int_1

Line 1661: FROM Ap_Invoices_All Aia,

1657:
1658: --collecting invoice amount
1659: CURSOR inv_amount_cur IS
1660: SELECT SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Inv_Amount
1661: FROM Ap_Invoices_All Aia,
1662: Xla_Transaction_Entities Ent,
1663: Xla_Ae_Headers Aeh,
1664: Xla_Ae_Lines Ael
1665: WHERE Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id

Line 1696: FROM Ap_Invoices_All Aia,

1692: --Begin: Updated for fixing bug# 9747960
1693: /*SELECT SUM(NVL(Ael.Entered_Dr,
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,

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 1780: FROM Ap_Invoices_All Aia,

1776: --End: Updated for fixing bug# 9747960
1777: UNION
1778: --collecting prepaid amount
1779: SELECT SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Paid_Amount
1780: FROM Ap_Invoices_All Aia,
1781: Xla_Transaction_Entities Ent,
1782: Xla_Ae_Headers Aeh,
1783: Xla_Ae_Lines Ael,
1784: Gl_Je_Headers Jeh,

Line 1893: FROM Ap_Invoices_All Aia,

1889:
1890: --collecting prepayment amount
1891: CURSOR prepaid_amount_cur IS
1892: SELECT SUM(NVL(Ael.Entered_Dr, 0) + -1 * NVL(Ael.Entered_Cr, 0)) Prepaid_Amount
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

Line 2471: from ap_invoices_all ai

2467: select AP_INVOICES_PKG.GET_APPROVAL_STATUS(ai.invoice_id,
2468: ai.invoice_amount,
2469: ai.payment_status_flag,
2470: ai.invoice_type_lookup_code) into l_invoice_status
2471: from ap_invoices_all ai
2472: where invoice_id = p_invioce_id;
2473:
2474: select EVENT_TYPE_CODE
2475: into l_enent_type_code

Line 2549: from ap_invoices_all ai

2545: ai.invoice_amount,
2546: ai.payment_status_flag,
2547: ai.invoice_type_lookup_code)
2548: into l_invoice_status
2549: from ap_invoices_all ai
2550: where invoice_id = p_invioce_id;
2551: if l_invoice_status='CANCELLED' then
2552: for l_invoice in cur_invoice
2553: loop

Line 2706: FROM Ap_Invoices_All Aia,

2702:
2703: --Step 2: Cursor for fetching invoice id
2704: CURSOR inv_id_cur(ln_ae_header_id NUMBER) IS
2705: SELECT Aia.Invoice_Id Invoice_Id
2706: FROM Ap_Invoices_All Aia,
2707: Xla_Transaction_Entities Ent,
2708: Xla_Ae_Headers Aeh
2709: WHERE Ent.Application_Id = 200
2710: AND Aia.Invoice_Id = Ent.Source_Id_Int_1

Line 2717: FROM Ap_Invoices_All Aia,

2713: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2714: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
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

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 2806: FROM Ap_Invoices_All Aia,

2802: Aia.Payment_Method_Code Settlement_Method_Number,
2803: NULL Payment_Date,
2804: '' Clear_Flag,
2805: '' Remittance_Bill_Number
2806: FROM Ap_Invoices_All Aia,
2807: Pa_Projects_All Pap,
2808: Po_Headers_All Pha,
2809: Fnd_Currencies_Vl Fcv,
2810: Xla_Transaction_Entities Ent,

Line 2887: FROM Ap_Invoices_All Aia,

2883: Ach.Payment_Method_Code Settlement_Method_Number,
2884: TO_CHAR(Ach.CHECK_DATE, 'YYYYMMDD') Payment_Date,
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,

Line 2975: FROM Ap_Invoices_All Aia,

2971: Aia.Payment_Method_Code Settlement_Method_Number,
2972: '' Payment_Date,
2973: DECODE(Aia.PAYMENT_STATUS_FLAG, 'Y', '1', '0') Clear_Flag,
2974: '' Remittance_Bill_Number
2975: FROM Ap_Invoices_All Aia,
2976: Xla_Transaction_Entities Ent,
2977: Xla_Ae_Headers Aeh,
2978: Xla_Ae_Lines Ael,
2979: Gl_Je_Headers Jeh,