DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1617: ap_invoice_distributions aid,

1613: DECODE(SIGN(tmp.quantity_ordered - tmp.quantity_billed), -1,
1614: 'IGC_PO_YEP_PO_OVERBILLED')))) result_error_code
1615: FROM ap_invoices ai,
1616: ap_invoice_payments aip,
1617: ap_invoice_distributions aid,
1618: igc_cbc_po_process_gt tmp
1619: WHERE ai.invoice_id = aid.invoice_id
1620: AND aip.invoice_id(+) = ai.invoice_id
1621: AND aid.po_distribution_id = tmp.distribution_id

Line 1645: ap_invoice_distributions aid,

1641: DECODE(SIGN(tmp.quantity_ordered - tmp.quantity_billed), -1,
1642: 'IGC_PO_YEP_REL_OVERBILLED')))) result_error_code
1643: FROM ap_invoices ai,
1644: ap_invoice_payments aip,
1645: ap_invoice_distributions aid,
1646: igc_cbc_po_process_gt tmp
1647: WHERE ai.invoice_id = aid.invoice_id
1648: AND aip.invoice_id(+) = ai.invoice_id
1649: AND aid.po_distribution_id = tmp.distribution_id