APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_GT

Line 274: INSERT INTO ap_invoice_distributions_gt

270: END IF;
271: --
272:
273: --This insert statement below was added for Bug 7284987 / 7392117
274: INSERT INTO ap_invoice_distributions_gt
275: ( invoice_distribution_id,
276: invoice_id,
277: invoice_line_number,
278: po_distribution_id,

Line 389: --AP_INVOICE_DISTRIBUTIONS_GT (APIDG) instead of AP_INVOICE_DISTRIBUTIONS_ALL (APID)

385: AND APID.posted_flag = 'Y'
386: AND APID.set_of_books_id = P_ledger_id ; */
387:
388: --The insert statement below has been modified for Bug 7284987 / 7392117 to use the table
389: --AP_INVOICE_DISTRIBUTIONS_GT (APIDG) instead of AP_INVOICE_DISTRIBUTIONS_ALL (APID)
390: --All occurances of APID have been replaced by APIDG
391: INSERT INTO FA_MASS_ADDITIONS_GT(
392: mass_addition_id,
393: asset_number,

Line 612: FROM ap_invoice_distributions_gt APIDG, --Bug 7284987 / 7392117

608: APIL.warranty_number,
609: APIDG.line_type_lookup_code,
610: POD.po_distribution_id,
611: 'NEW'
612: FROM ap_invoice_distributions_gt APIDG, --Bug 7284987 / 7392117
613: ap_invoice_lines_all APIL,
614: ap_invoices_all API,
615: ap_batches_all APB,
616: po_distributions_all POD,

Line 674: INSERT INTO ap_invoice_distributions_gt

670: END IF;
671: --
672:
673: --This insert statement below was added for Bug 7284987 / 7392117
674: INSERT INTO ap_invoice_distributions_gt
675: ( invoice_distribution_id,
676: invoice_id,
677: invoice_line_number,
678: po_distribution_id,

Line 791: --AP_INVOICE_DISTRIBUTIONS_GT (APIDG) instead of AP_INVOICE_DISTRIBUTIONS_ALL (APID)

787: AND APID.cash_posted_flag = 'Y'
788: AND APID.set_of_books_id = P_ledger_id ; */
789:
790: --The insert statement below has been modified for Bug 7284987 / 7392117 to use the table
791: --AP_INVOICE_DISTRIBUTIONS_GT (APIDG) instead of AP_INVOICE_DISTRIBUTIONS_ALL (APID)
792: --All occurances of APID have been replaced by APIDG
793: INSERT INTO FA_MASS_ADDITIONS_GT(
794: mass_addition_id,
795: asset_number,

Line 1014: FROM ap_invoice_distributions_gt APIDG, -- Bug 7284987 / 7392117

1010: APIL.warranty_number,
1011: APIDG.line_type_lookup_code,
1012: POD.po_distribution_id,
1013: 'NEW'
1014: FROM ap_invoice_distributions_gt APIDG, -- Bug 7284987 / 7392117
1015: ap_invoice_lines_all APIL,
1016: ap_invoices_all API,
1017: ap_batches_all APB,
1018: po_distributions_all POD,

Line 1079: FROM ap_invoice_distributions_gt APIDG)

1075: UPDATE ap_invoice_distributions_all AID
1076: SET AID.assets_addition_flag = 'N'
1077: WHERE AID.invoice_distribution_id IN
1078: (SELECT APIDG.invoice_distribution_id
1079: FROM ap_invoice_distributions_gt APIDG)
1080: AND AID.invoice_distribution_id NOT IN
1081: (SELECT FAGT.invoice_distribution_id
1082: FROM fa_mass_additions_gt FAGT);
1083: