DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on AP_INV_DISTS_TARGET

Line 1559: -- into the ap_inv_dists_target table from the existing 11i distributions.

1555: ------------------------------------------------------------------
1556: -- Procedure TRANSFORM_DISTRIBUTIONS
1557: -- Purpose
1558: -- This procedure TRANSFORM_DISTRIBUTIONS inserts the new distributions
1559: -- into the ap_inv_dists_target table from the existing 11i distributions.
1560: ------------------------------------------------------------------
1561: PROCEDURE Transform_Distributions
1562: (p_start_rowid ROWID,
1563: p_end_rowid ROWID,

Line 1592: INSERT INTO ap_inv_dists_target t1

1588: /* This insert statement will insert all the ITEM, PREPAY
1589: and AWT type of distributions based on the data from the
1590: ap_invoice_distributions table of 11i. */
1591:
1592: INSERT INTO ap_inv_dists_target t1
1593: (BATCH_ID,
1594: INVOICE_ID,
1595: INVOICE_LINE_NUMBER,
1596: INVOICE_DISTRIBUTION_ID,

Line 2012: INSERT INTO ap_inv_dists_target t1

2008: based on the data from ap_invoice_distributions and
2009: ap_chrg_allocations of 11i. */
2010:
2011:
2012: INSERT INTO ap_inv_dists_target t1
2013: (BATCH_ID,
2014: INVOICE_ID,
2015: INVOICE_LINE_NUMBER,
2016: INVOICE_DISTRIBUTION_ID,