APPS.JE_JEFILPIP_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 587: AP_INVOICE_DISTRIBUTIONS_ALL ID,

583: ,ID.AMOUNT)) PREPAY_AMT,
584: SUM(ID.AMOUNT) INVPP_OPEN_AMOUNT,
585: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
586: FROM
587: AP_INVOICE_DISTRIBUTIONS_ALL ID,
588: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
589: AP_INVOICES_ALL PP
590: WHERE ID.INVOICE_ID = P_INVOICE_ID
591: AND ( ( ID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'

Line 588: AP_INVOICE_DISTRIBUTIONS_ALL PPD,

584: SUM(ID.AMOUNT) INVPP_OPEN_AMOUNT,
585: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
586: FROM
587: AP_INVOICE_DISTRIBUTIONS_ALL ID,
588: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
589: AP_INVOICES_ALL PP
590: WHERE ID.INVOICE_ID = P_INVOICE_ID
591: AND ( ( ID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'
592: AND ID.PREPAY_DISTRIBUTION_ID = PPD.INVOICE_DISTRIBUTION_ID ) )

Line 604: AP_INVOICE_DISTRIBUTIONS_ALL ID,

600: ,ID.AMOUNT)) PREPAY_AMT,
601: SUM(ID.AMOUNT) INVPP_OPEN_AMOUNT,
602: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
603: FROM
604: AP_INVOICE_DISTRIBUTIONS_ALL ID,
605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
606: AP_INVOICE_DISTRIBUTIONS_ALL AID,
607: AP_INVOICES_ALL PP
608: WHERE ID.INVOICE_ID = P_INVOICE_ID

Line 605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,

601: SUM(ID.AMOUNT) INVPP_OPEN_AMOUNT,
602: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
603: FROM
604: AP_INVOICE_DISTRIBUTIONS_ALL ID,
605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
606: AP_INVOICE_DISTRIBUTIONS_ALL AID,
607: AP_INVOICES_ALL PP
608: WHERE ID.INVOICE_ID = P_INVOICE_ID
609: AND ID.LINE_TYPE_LOOKUP_CODE = 'TAX'

Line 606: AP_INVOICE_DISTRIBUTIONS_ALL AID,

602: MAX(ID.ACCOUNTING_DATE) INVPP_GL_DATE
603: FROM
604: AP_INVOICE_DISTRIBUTIONS_ALL ID,
605: AP_INVOICE_DISTRIBUTIONS_ALL PPD,
606: AP_INVOICE_DISTRIBUTIONS_ALL AID,
607: AP_INVOICES_ALL PP
608: WHERE ID.INVOICE_ID = P_INVOICE_ID
609: AND ID.LINE_TYPE_LOOKUP_CODE = 'TAX'
610: AND AID.LINE_TYPE_LOOKUP_CODE = 'PREPAY'