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.PAAPIMP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 2018: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol

2014: /* Bug 6353803: Added the following for this bug. */
2015: AND (pa_nl_installed.is_nl_installed = 'N'
2016: OR ( pa_nl_installed.is_nl_installed = 'Y'
2017: AND NOT EXISTS (SELECT 'X'
2018: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2019: WHERE pod.po_distribution_id = dist.po_distribution_id
2020: AND pod.po_line_id = pol.po_line_id
2021: AND si.inventory_item_id = pol.item_id
2022: AND si.comms_nl_trackable_flag = 'Y'

Line 2029: mtl_system_items si,

2025: AND NOT EXISTS (SELECT 'X'
2026: FROM
2027: ap_invoice_distributions apdist,
2028: po_distributions pod,
2029: mtl_system_items si,
2030: po_lines_all pol
2031: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2032: = apdist.INVOICE_DISTRIBUTION_ID
2033: and apdist.po_distribution_id = pod.po_distribution_id

Line 2091: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol

2087: /* Bug 6353803: Added the following for this bug. */
2088: AND (pa_nl_installed.is_nl_installed = 'N'
2089: OR ( pa_nl_installed.is_nl_installed = 'Y'
2090: AND NOT EXISTS (SELECT 'X'
2091: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2092: WHERE pod.po_distribution_id = dist.po_distribution_id
2093: AND pod.po_line_id = pol.po_line_id
2094: AND si.inventory_item_id = pol.item_id
2095: AND si.comms_nl_trackable_flag = 'Y'

Line 2102: mtl_system_items si,

2098: AND NOT EXISTS (SELECT 'X'
2099: FROM
2100: ap_invoice_distributions apdist,
2101: po_distributions pod,
2102: mtl_system_items si,
2103: po_lines_all pol
2104: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2105: = apdist.INVOICE_DISTRIBUTION_ID
2106: and apdist.po_distribution_id = pod.po_distribution_id

Line 2165: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol

2161: /* Bug 6353803: Added the following for this bug. */
2162: AND (pa_nl_installed.is_nl_installed = 'N'
2163: OR ( pa_nl_installed.is_nl_installed = 'Y'
2164: AND NOT EXISTS (SELECT 'X'
2165: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2166: WHERE pod.po_distribution_id = dist.po_distribution_id
2167: AND pod.po_line_id = pol.po_line_id
2168: AND si.inventory_item_id = pol.item_id
2169: AND si.comms_nl_trackable_flag = 'Y'

Line 2176: mtl_system_items si,

2172: AND NOT EXISTS (SELECT 'X'
2173: FROM
2174: ap_invoice_distributions apdist,
2175: po_distributions pod,
2176: mtl_system_items si,
2177: po_lines_all pol
2178: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2179: = apdist.INVOICE_DISTRIBUTION_ID
2180: and apdist.po_distribution_id = pod.po_distribution_id

Line 2257: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol

2253: /* Bug 6353803: Added the following for this bug. */
2254: AND (pa_nl_installed.is_nl_installed = 'N'
2255: OR ( pa_nl_installed.is_nl_installed = 'Y'
2256: AND NOT EXISTS (SELECT 'X'
2257: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2258: WHERE pod.po_distribution_id = dist.po_distribution_id
2259: AND pod.po_line_id = pol.po_line_id
2260: AND si.inventory_item_id = pol.item_id
2261: AND si.comms_nl_trackable_flag = 'Y'

Line 2268: mtl_system_items si,

2264: AND NOT EXISTS (SELECT 'X'
2265: FROM
2266: ap_invoice_distributions apdist,
2267: po_distributions pod,
2268: mtl_system_items si,
2269: po_lines_all pol
2270: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2271: = apdist.INVOICE_DISTRIBUTION_ID
2272: and apdist.po_distribution_id = pod.po_distribution_id

Line 2329: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol

2325: /* Bug 6353803: Added the following for this bug. */
2326: AND (pa_nl_installed.is_nl_installed = 'N'
2327: OR ( pa_nl_installed.is_nl_installed = 'Y'
2328: AND NOT EXISTS (SELECT 'X'
2329: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2330: WHERE pod.po_distribution_id = dist.po_distribution_id
2331: AND pod.po_line_id = pol.po_line_id
2332: AND si.inventory_item_id = pol.item_id
2333: AND si.comms_nl_trackable_flag = 'Y'

Line 2340: mtl_system_items si,

2336: AND NOT EXISTS (SELECT 'X'
2337: FROM
2338: ap_invoice_distributions apdist,
2339: po_distributions pod,
2340: mtl_system_items si,
2341: po_lines_all pol
2342: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2343: = apdist.INVOICE_DISTRIBUTION_ID
2344: and apdist.po_distribution_id = pod.po_distribution_id

Line 2404: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol

2400: /* Bug 6353803: Added the following for this bug. */
2401: AND (pa_nl_installed.is_nl_installed = 'N'
2402: OR ( pa_nl_installed.is_nl_installed = 'Y'
2403: AND NOT EXISTS (SELECT 'X'
2404: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2405: WHERE pod.po_distribution_id = dist.po_distribution_id
2406: AND pod.po_line_id = pol.po_line_id
2407: AND si.inventory_item_id = pol.item_id
2408: AND si.comms_nl_trackable_flag = 'Y'

Line 2415: mtl_system_items si,

2411: AND NOT EXISTS (SELECT 'X'
2412: FROM
2413: ap_invoice_distributions apdist,
2414: po_distributions pod,
2415: mtl_system_items si,
2416: po_lines_all pol
2417: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2418: = apdist.INVOICE_DISTRIBUTION_ID
2419: and apdist.po_distribution_id = pod.po_distribution_id

Line 7489: FROM mtl_system_items si,

7485: WHERE inv.invoice_id = dist.invoice_id
7486: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','NONREC_TAX')
7487: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
7488: AND EXISTS (SELECT 'X'
7489: FROM mtl_system_items si,
7490: po_lines_all pol,
7491: po_distributions_all po_dist1
7492: WHERE po_dist1.po_line_id = pol.po_line_id
7493: AND po_dist1.po_distribution_id = dist.po_distribution_id

Line 7619: FROM mtl_system_items si,

7615: WHERE inv.invoice_id = dist.invoice_id
7616: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','NONREC_TAX')
7617: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
7618: AND EXISTS (SELECT 'X'
7619: FROM mtl_system_items si,
7620: po_lines_all pol,
7621: po_distributions_all po_dist1
7622: WHERE po_dist1.po_line_id = pol.po_line_id
7623: AND po_dist1.po_distribution_id = dist.po_distribution_id