DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_INV_DISTS_TARGET

Line 59: DELETE FROM AP_Inv_Dists_Target

55: DELETE FROM AP_Invoice_Lines_All
56: WHERE invoice_id = sync_invs(i);
57:
58: FORALL i IN 1..sync_invs.COUNT
59: DELETE FROM AP_Inv_Dists_Target
60: WHERE invoice_id = sync_invs(i);
61: /*
62:
63: FORALL i IN 1..sync_invs.COUNT

Line 1433: INSERT INTO ap_inv_dists_target t1

1429: /* This insert statement will insert all the ITEM, PREPAY
1430: and AWT type of distributions based on the data from the
1431: ap_invoice_distributions table of 11i. */
1432:
1433: INSERT INTO ap_inv_dists_target t1
1434: (BATCH_ID,
1435: INVOICE_ID,
1436: INVOICE_LINE_NUMBER,
1437: INVOICE_DISTRIBUTION_ID,

Line 1835: INSERT INTO ap_inv_dists_target t1

1831: based on the data from ap_invoice_distributions and
1832: ap_chrg_allocations of 11i. */
1833:
1834:
1835: INSERT INTO ap_inv_dists_target t1
1836: (BATCH_ID,
1837: INVOICE_ID,
1838: INVOICE_LINE_NUMBER,
1839: INVOICE_DISTRIBUTION_ID,