eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_GT

Line 389: INSERT INTO ap_invoice_distributions_gt

385:
386: --This insert statement below was added for Bug 7284987 / 7392117
387: -- for bug 9669334 we have spilt the query. first part is for ITEM and ACCRUAL.
388: -- second one is for other line type lookups.
389: INSERT INTO ap_invoice_distributions_gt
390: (invoice_distribution_id,
391: invoice_id,
392: invoice_line_number,
393: po_distribution_id,

Line 819: FROM ap_invoice_distributions_gt APIDG,

815: APIL.warranty_number,
816: APIDG.line_type_lookup_code,
817: POD.po_distribution_id,
818: 'NEW'
819: FROM ap_invoice_distributions_gt APIDG,
820: ap_invoice_lines_all APIL,
821: ap_invoices_all API,
822: financials_system_params_all FSP, -- changed table order # 9669334
823: ap_batches_all APB,

Line 888: INSERT INTO ap_invoice_distributions_gt

884:
885: --This insert statement below was added for Bug 7284987 / 7392117
886: -- for bug 9669334 we have spilt the query. first part is for ITEM and ACCRUAL.
887: -- second one is for other line type lookups.
888: INSERT INTO ap_invoice_distributions_gt
889: (invoice_distribution_id,
890: invoice_id,
891: invoice_line_number,
892: po_distribution_id,

Line 1323: FROM ap_invoice_distributions_gt APIDG,

1319: APIL.warranty_number,
1320: APIDG.line_type_lookup_code,
1321: POD.po_distribution_id,
1322: 'NEW'
1323: FROM ap_invoice_distributions_gt APIDG,
1324: ap_invoice_lines_all APIL,
1325: ap_invoices_all API,
1326: AP_PAYMENT_HIST_DISTS APHD, --Bug9967535
1327: financials_system_params_all FSP, -- changed table order # 9669334

Line 1402: FROM ap_invoice_distributions_gt APIDG

1398: UPDATE ap_invoice_distributions_all AID
1399: SET AID.assets_addition_flag = 'N'
1400: WHERE AID.invoice_distribution_id IN
1401: (SELECT APIDG.invoice_distribution_id
1402: FROM ap_invoice_distributions_gt APIDG
1403: where charge_applicable_to_dist_id is null
1404: AND NOT EXISTS
1405: (SELECT 1
1406: FROM fa_mass_additions_gt FAGT

Line 1420: FROM AP_INVOICE_DISTRIBUTIONS_GT APIDG

1416: SET AID.ASSETS_ADDITION_FLAG = 'N'
1417: WHERE
1418: AID.INVOICE_DISTRIBUTION_ID IN
1419: ( SELECT APIDG.INVOICE_DISTRIBUTION_ID
1420: FROM AP_INVOICE_DISTRIBUTIONS_GT APIDG
1421: WHERE
1422: CHARGE_APPLICABLE_TO_DIST_ID IS NOT NULL
1423: AND NOT EXISTS
1424: (

Line 1444: FROM ap_invoice_distributions_gt APIDG)

1440: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL AID
1441: SET AID.assets_addition_flag = 'N'
1442: WHERE AID.invoice_distribution_id IN
1443: (SELECT APIDG.invoice_distribution_id
1444: FROM ap_invoice_distributions_gt APIDG)
1445: AND AID.invoice_distribution_id NOT IN
1446: (SELECT FAGT.invoice_distribution_id
1447: FROM fa_mass_additions_gt FAGT)
1448: -- bug 7215835: add end