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_ALL

Line 318: ap_invoice_distributions_all item

314: APID.charge_applicable_to_dist_id,
315: nvl(APID.asset_book_type_code,item.asset_book_type_code),
316: APID.set_of_books_id
317: FROM ap_invoice_distributions APID,
318: ap_invoice_distributions_all item
319: WHERE APID.accounting_date <= P_acctg_date
320: AND APID.assets_addition_flag = 'U'
321: AND decode(apid.line_type_lookup_code,'ITEM', apid.assets_tracking_flag,
322: 'ACCRUAL',apid.assets_tracking_flag, nvl(item.assets_tracking_flag, 'N') ) = 'Y'

Line 365: FROM ap_invoice_distributions_all APIDV

361: AND ( ( APID.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
362: AND APID.assets_tracking_flag = 'Y' )
363: OR EXISTS
364: ( SELECT 'X'
365: FROM ap_invoice_distributions_all APIDV
366: WHERE APID.related_id = APIDV.invoice_distribution_id
367: AND APID.invoice_distribution_id <> APID.related_id --bug6415366
368: AND APIDV.assets_tracking_flag = 'Y')
369: OR EXISTS

Line 371: FROM ap_invoice_distributions_all APIDC

367: AND APID.invoice_distribution_id <> APID.related_id --bug6415366
368: AND APIDV.assets_tracking_flag = 'Y')
369: OR EXISTS
370: ( SELECT 'X'
371: FROM ap_invoice_distributions_all APIDC
372: WHERE APID.charge_applicable_to_dist_id =
373: APIDC.invoice_distribution_id
374: AND APIDC.assets_tracking_flag = 'Y')
375: )

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 718: ap_invoice_distributions_all item

714: APID.charge_applicable_to_dist_id,
715: nvl(APID.asset_book_type_code,item.asset_book_type_code),
716: APID.set_of_books_id
717: FROM ap_invoice_distributions APID,
718: ap_invoice_distributions_all item
719: WHERE APID.accounting_date <= P_acctg_date
720: AND APID.assets_addition_flag = 'U'
721: AND decode(apid.line_type_lookup_code,'ITEM', apid.assets_tracking_flag,
722: 'ACCRUAL',apid.assets_tracking_flag, nvl(item.assets_tracking_flag, 'N') ) = 'Y'

Line 766: FROM ap_invoice_distributions_all APIDV

762: AND ( ( APID.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
763: AND APID.assets_tracking_flag = 'Y' )
764: OR EXISTS
765: ( SELECT 'X'
766: FROM ap_invoice_distributions_all APIDV
767: WHERE APID.related_id = APIDV.invoice_distribution_id
768: AND APID.invoice_distribution_id <> APID.related_id --bug6415366
769: AND APIDV.assets_tracking_flag = 'Y')
770: OR EXISTS

Line 772: FROM ap_invoice_distributions_all APIDC

768: AND APID.invoice_distribution_id <> APID.related_id --bug6415366
769: AND APIDV.assets_tracking_flag = 'Y')
770: OR EXISTS
771: ( SELECT 'X'
772: FROM ap_invoice_distributions_all APIDC
773: WHERE APID.charge_applicable_to_dist_id =
774: APIDC.invoice_distribution_id
775: AND APIDC.assets_tracking_flag = 'Y')
776: )

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 1075: UPDATE ap_invoice_distributions_all AID

1071: not picked up by fass addition gt table but picked by
1072: distributions gt table. by stamping these to N will
1073: avoid from picking up again while loading distributions gt
1074: */
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)

Line 1142: ap_invoice_distributions_all APID

1138: AND APIP.set_of_books_id = P_ledger_id
1139: AND APIP.invoice_payment_id IN (
1140: SELECT APHD.invoice_payment_id
1141: FROM ap_payment_hist_dists APHD,
1142: ap_invoice_distributions_all APID
1143: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
1144: AND APIP.ACCOUNTING_EVENT_ID=APHD.ACCOUNTING_EVENT_ID --bug5461146
1145: AND APHD.invoice_distribution_id = APID.invoice_distribution_id
1146: AND APHD.pay_dist_lookup_code = 'DISCOUNT'

Line 1155: FROM ap_invoice_distributions_all APIDV

1151: AND ( (APID.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
1152: AND APID.assets_tracking_flag = 'Y')
1153: OR EXISTS
1154: ( SELECT 'X'
1155: FROM ap_invoice_distributions_all APIDV
1156: WHERE APID.related_id =
1157: APIDV.invoice_distribution_id
1158: AND APIDV.invoice_distribution_id <> APIDV.related_id
1159: AND APIDV.assets_tracking_flag = 'Y')

Line 1162: FROM ap_invoice_distributions_all APIDC

1158: AND APIDV.invoice_distribution_id <> APIDV.related_id
1159: AND APIDV.assets_tracking_flag = 'Y')
1160: OR EXISTS
1161: ( SELECT 'X'
1162: FROM ap_invoice_distributions_all APIDC
1163: WHERE APID.charge_applicable_to_dist_id =
1164: APIDC.invoice_distribution_id
1165: AND APIDC.assets_tracking_flag = 'Y')
1166: )

Line 1413: FROM ap_invoice_distributions_all APID,

1409: 'DISCOUNT',
1410: POD.po_distribution_id,
1411: 'NEW',
1412: APIP.invoice_payment_id
1413: FROM ap_invoice_distributions_all APID,
1414: ap_invoice_lines_all APIL,
1415: ap_invoice_payments_all APIP,
1416: ap_payment_hist_dists APHD,
1417: ap_invoices_all API,

Line 1443: FROM ap_invoice_distributions_all APIDV

1439: AND ( (APID.line_type_lookup_code IN ('ITEM', 'ACCRUAL')
1440: AND APID.assets_tracking_flag = 'Y')
1441: OR EXISTS
1442: ( SELECT 'X'
1443: FROM ap_invoice_distributions_all APIDV
1444: WHERE APID.related_id =
1445: APIDV.invoice_distribution_id
1446: AND APID.invoice_distribution_id <> APID.related_id --bug6415366
1447: AND APIDV.assets_tracking_flag = 'Y')

Line 1450: FROM ap_invoice_distributions_all APIDC

1446: AND APID.invoice_distribution_id <> APID.related_id --bug6415366
1447: AND APIDV.assets_tracking_flag = 'Y')
1448: OR EXISTS
1449: ( SELECT 'X'
1450: FROM ap_invoice_distributions_all APIDC
1451: WHERE APID.charge_applicable_to_dist_id =
1452: APIDC.invoice_distribution_id
1453: AND APIDC.assets_tracking_flag = 'Y')
1454: )

Line 1638: UPDATE ap_invoice_distributions_all APID

1634: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,
1635: 'Updating AID records to N which EIB sends to FA ');
1636: END IF;
1637: --
1638: UPDATE ap_invoice_distributions_all APID
1639: SET APID.assets_addition_flag = 'N',
1640: APID.program_update_date = SYSDATE,
1641: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1642: APID.program_id = FND_GLOBAL.conc_program_id,

Line 1775: UPDATE ap_invoice_distributions_all APID

1771: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
1772: END IF;
1773: --
1774: /* BUG 8236268
1775: UPDATE ap_invoice_distributions_all APID
1776: SET APID.assets_addition_flag = 'Y',
1777: APID.program_update_date = SYSDATE,
1778: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1779: APID.program_id = FND_GLOBAL.conc_program_id,

Line 1798: FROM ap_invoice_distributions_all apid,

1794: apid.program_id,
1795: apid.request_id,
1796: apid.asset_book_type_code,
1797: fmag.book_type_code
1798: FROM ap_invoice_distributions_all apid,
1799: fa_mass_additions_gt fmag
1800: WHERE apid.invoice_distribution_id = fmag.invoice_distribution_id
1801: AND fmag.line_status = 'PROCESSED'
1802: AND fmag.ledger_id = l_ledger_id

Line 1820: UPDATE ap_invoice_distributions_all APID

1816: ||'after successfully transferred to Asset: '
1817: ||TO_CHAR(l_count));
1818: END IF;
1819: --
1820: UPDATE ap_invoice_distributions_all APID
1821: SET APID.assets_addition_flag = 'N',
1822: APID.program_update_date = SYSDATE,
1823: APID.program_application_id = FND_GLOBAL.prog_appl_id,
1824: APID.program_id = FND_GLOBAL.conc_program_id,

Line 2011: ap_invoice_distributions_all APID,

2007: AND APIP.set_of_books_id = l_ledger_id
2008: AND APIP.invoice_payment_id IN (
2009: SELECT APHD.invoice_payment_id
2010: FROM ap_payment_hist_dists APHD,
2011: ap_invoice_distributions_all APID,
2012: fa_mass_additions_gt FMAG
2013: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
2014: AND APHD.invoice_distribution_id =
2015: APID.invoice_distribution_id

Line 2039: ap_invoice_distributions_all APID,

2035: AND APIP.set_of_books_id = l_ledger_id
2036: AND APIP.invoice_payment_id IN (
2037: SELECT APHD.invoice_payment_id
2038: FROM ap_payment_hist_dists APHD,
2039: ap_invoice_distributions_all APID,
2040: fa_mass_additions_gt FMAG
2041: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
2042: AND APHD.invoice_distribution_id =
2043: APID.invoice_distribution_id