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.AP_CREATE_PAY_SCHEDS_PKG dependencies on AP_INVOICES

Line 176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;

172: l_last_line_flag BOOLEAN;
173: l_dummy VARCHAR2(200);
174: current_calling_sequence VARCHAR2(2000);
175: debug_info VARCHAR2(100);
176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;

Line 177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;

173: l_dummy VARCHAR2(200);
174: current_calling_sequence VARCHAR2(2000);
175: debug_info VARCHAR2(100);
176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
181: l_precision_inv_curr fnd_currencies.precision%TYPE;

Line 310: FROM ap_invoices

306: SELECT invoice_type_lookup_code,
307: vendor_site_id
308: INTO l_invoice_type,
309: l_vendor_site_id
310: FROM ap_invoices
311: WHERE invoice_id = P_Invoice_Id;
312:
313:
314: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 452: , ap_invoices ai

448: l_discount_amount, l_discount_amount_2, l_discount_amount_3
449:
450: FROM ap_terms
451: , ap_terms_lines
452: , ap_invoices ai
453: WHERE ap_terms.term_id = ap_terms_lines.term_id
454: AND ap_terms_lines.term_id = P_Terms_Id
455: AND ap_terms_lines.sequence_num = l_sequence_num
456: AND ai.Invoice_Id = P_Invoice_Id;

Line 663: , ap_invoices ai

659: T_REMIT_TO_SUPPLIER_SITE_ID(l_payment_schedule_index),
660: T_RELATIONSHIP_ID(l_payment_schedule_index)
661: FROM ap_terms
662: , ap_terms_lines
663: , ap_invoices ai
664: WHERE ap_terms.term_id = ap_terms_lines.term_id
665: AND ap_terms_lines.term_id = P_Terms_Id
666: AND ap_terms_lines.sequence_num = l_sequence_num
667: AND ai.Invoice_Id = P_Invoice_Id;

Line 780: ap_invoices ai

776: l_discount_amount, l_discount_amount_2, l_discount_amount_3
777:
778: FROM ap_terms,
779: ap_terms_lines,
780: ap_invoices ai
781: WHERE ap_terms.term_id = ap_terms_lines.term_id
782: AND ap_terms_lines.term_id = P_Terms_Id
783: AND ap_terms_lines.sequence_num = l_sequence_num
784: AND ai.invoice_id = P_Invoice_Id;

Line 990: , ap_invoices ai

986: T_REMIT_TO_SUPPLIER_SITE_ID(l_payment_schedule_index),
987: T_RELATIONSHIP_ID(l_payment_schedule_index)
988: FROM ap_terms
989: , ap_terms_lines
990: , ap_invoices ai
991: WHERE ap_terms.term_id = ap_terms_lines.term_id
992: AND ap_terms_lines.term_id = P_Terms_Id
993: AND ap_terms_lines.sequence_num = l_sequence_num
994: AND ai.invoice_id = P_Invoice_Id;

Line 1153: ap_invoices_pkg.validate_docs_payable(T_INVOICE_ID(j),

1149: p_calling_sequence => current_calling_sequence);
1150:
1151:
1152: FOR j IN 1..l_payment_schedule_index loop
1153: ap_invoices_pkg.validate_docs_payable(T_INVOICE_ID(j),
1154: T_PAYMENT_NUM(j),
1155: l_hold_flag); --not used
1156: end loop;
1157:

Line 1231: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;

1227: l_last_line_flag BOOLEAN;
1228: l_dummy VARCHAR2(200);
1229: current_calling_sequence VARCHAR2(2000);
1230: debug_info VARCHAR2(100);
1231: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
1232: l_orig_ext_bank_acct_id number; /*bug 1274099*/
1233: l_orig_ext_bank_exists varchar2(1);
1234: --bug 2143298 Included local variable to store invoice type
1235: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;

Line 1235: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;

1231: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
1232: l_orig_ext_bank_acct_id number; /*bug 1274099*/
1233: l_orig_ext_bank_exists varchar2(1);
1234: --bug 2143298 Included local variable to store invoice type
1235: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
1236: l_Payment_Priority NUMBER(15):=NULL; /*Bug fix:1635550*/
1237:
1238: -- Bug Fix: 1952122
1239: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;

Line 1309: ap_invoices ai,

1305: CURSOR c_orig_bank_acct_vendor IS --BUG 1274099, checks at the vendor level
1306:
1307: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7437597
1308: FROM ap_payment_schedules aps,
1309: ap_invoices ai,
1310: iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1311: po_vendors pv
1312: WHERE ai.invoice_id = p_invoice_id
1313: AND ai.vendor_id = pv.vendor_id

Line 1323: ap_invoices ai,

1319:
1320: CURSOR c_orig_bank_acct_vend_site IS
1321: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7437597
1322: FROM ap_payment_schedules aps,
1323: ap_invoices ai,
1324: iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1325: po_vendors pv
1326: WHERE ai.invoice_id = p_invoice_id
1327: AND ai.vendor_id = pv.vendor_id

Line 1428: FROM ap_invoices

1424: -- for credit/debit memo
1425:
1426: SELECT invoice_type_lookup_code
1427: INTO l_invoice_type
1428: FROM ap_invoices
1429: WHERE invoice_id = P_Invoice_Id;
1430:
1431:
1432: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1580: , ap_invoices ai

1576: l_discount_amount, l_discount_amount_2, l_discount_amount_3
1577:
1578: FROM ap_terms
1579: , ap_terms_lines
1580: , ap_invoices ai
1581: WHERE ap_terms.term_id = ap_terms_lines.term_id
1582: AND ap_terms_lines.term_id = P_Terms_Id
1583: AND ap_terms_lines.sequence_num = l_sequence_num
1584: AND ai.Invoice_Id = P_Invoice_Id;

Line 1796: ap_invoices ai,

1792: ,ai.remit_to_supplier_site_id
1793: ,ai.relationship_id
1794: FROM ap_terms,
1795: ap_terms_lines,
1796: ap_invoices ai,
1797: ap_recurring_payments arp --bug 5332569
1798: WHERE ap_terms.term_id = ap_terms_lines.term_id
1799: AND ap_terms_lines.term_id = P_Terms_Id
1800: AND ap_terms_lines.sequence_num = l_sequence_num

Line 1896: ap_invoices ai,

1892: l_discount_amount, l_discount_amount_2, l_discount_amount_3
1893:
1894: FROM ap_terms,
1895: ap_terms_lines,
1896: ap_invoices ai,
1897: ap_recurring_payments arp
1898: WHERE ap_terms.term_id = ap_terms_lines.term_id
1899: AND ap_terms_lines.term_id = P_Terms_Id
1900: AND ap_terms_lines.sequence_num = l_sequence_num

Line 2129: ap_invoices ai,

2125: ,ai.remit_to_supplier_site_id
2126: ,ai.relationship_id
2127: FROM ap_terms,
2128: ap_terms_lines,
2129: ap_invoices ai,
2130: ap_recurring_payments arp
2131: WHERE ap_terms.term_id = ap_terms_lines.term_id
2132: AND ap_terms_lines.term_id = P_Terms_Id
2133: AND ap_terms_lines.sequence_num = l_sequence_num

Line 2262: ap_invoices_pkg.validate_docs_payable(p_INVOICE_ID,null,l_hold_flag);

2258: WHERE invoice_id = P_Invoice_Id);
2259: END IF;
2260:
2261:
2262: ap_invoices_pkg.validate_docs_payable(p_INVOICE_ID,null,l_hold_flag);
2263:
2264:
2265:
2266: EXCEPTION