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

Line 524: AP_INVOICES ai

520: ftt.terms_type,
521: ai.terms_id -- Bug 11834795
522: from
523: FV_TERMS_TYPES ftt,
524: AP_INVOICES ai
525: -- AP_PAYMENT_SCHEDULES aps
526: where
527: ftt.term_id = ai.terms_id and
528: ai.invoice_id = x_invoice_id and

Line 535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;

531: x_discount_amount > 0;
532:
533: err_message varchar2(5000);
534: /* Fetch Variables for Cursor c1 */
535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;

Line 536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

532:
533: err_message varchar2(5000);
534: /* Fetch Variables for Cursor c1 */
535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;

Line 537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;

533: err_message varchar2(5000);
534: /* Fetch Variables for Cursor c1 */
535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
541: /*-------------Comments----------------------------------------------

Line 538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;

534: /* Fetch Variables for Cursor c1 */
535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
541: /*-------------Comments----------------------------------------------
542: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;

Line 539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;

535: X_Invoice_Num AP_INVOICES_ALL.INVOICE_NUM%TYPE;
536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
541: /*-------------Comments----------------------------------------------
542: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;
543: X_Discount_Date AP_PAYMENT_SCHEDULES.DISCOUNT_DATE%TYPE;

Line 540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;

536: X_Invoice_Amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
537: X_Invoice_Date AP_INVOICES_ALL.INVOICE_DATE%TYPE;
538: X_Invoice_Received_Date AP_INVOICES_ALL.INVOICE_RECEIVED_DATE%TYPE;
539: X_Goods_Received_Date AP_INVOICES_ALL.GOODS_RECEIVED_DATE%TYPE;
540: X_Terms_Date AP_INVOICES_ALL.TERMS_DATE%TYPE;
541: /*-------------Comments----------------------------------------------
542: X_Discount_Amount AP_PAYMENT_SCHEDULES.DISCOUNT_AMOUNT_AVAILABLE%TYPE;
543: X_Discount_Date AP_PAYMENT_SCHEDULES.DISCOUNT_DATE%TYPE;
544: --------------End of Comments---------------------------------------*/

Line 547: X_Terms_Id AP_INVOICES.TERMS_ID%TYPE;

543: X_Discount_Date AP_PAYMENT_SCHEDULES.DISCOUNT_DATE%TYPE;
544: --------------End of Comments---------------------------------------*/
545: x_Due_Date AP_SELECTED_INVOICES.DUE_DATE%TYPE;
546: -- Bug 11834795
547: X_Terms_Id AP_INVOICES.TERMS_ID%TYPE;
548: X_Payment_Date DATE;
549: X_Effective_Discount_Rate FV_DISCOUNTED_INVOICES.EFFECTIVE_DISCOUNT_PERCENT%TYPE;
550: X_CVOF_Rate FV_VALUE_OF_FUND_PERIODS.CURR_VALUE_OF_FUNDS_PERCENT%TYPE;
551: X_terms_type FV_TERMS_TYPES.TERMS_TYPE%TYPE;

Line 563: from ap_invoices_all

559: Begin
560:
561: select invoice_num
562: into X_Invoice_Num
563: from ap_invoices_all
564: where invoice_id = X_Invoice_id;
565:
566: --MOAC changes: Removed the org_id parameter in the call to FV_INSTALL.enabled
567: v_fv_enabled := fv_install.enabled; -- check if FV is enabled