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 2655: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol

2651: /* Bug 6353803: Added the following for this bug. */
2652: AND (pa_nl_installed.is_nl_installed = 'N'
2653: OR ( pa_nl_installed.is_nl_installed = 'Y'
2654: AND NOT EXISTS (SELECT 'X'
2655: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2656: WHERE pod.po_distribution_id = dist.po_distribution_id
2657: AND pod.po_line_id = pol.po_line_id
2658: AND si.inventory_item_id = pol.item_id
2659: AND si.comms_nl_trackable_flag = 'Y'

Line 2671: mtl_system_items si,

2667: AND NOT EXISTS (SELECT 'X'
2668: FROM
2669: ap_invoice_distributions apdist,
2670: po_distributions pod,
2671: mtl_system_items si,
2672: po_lines_all pol
2673: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2674: = apdist.INVOICE_DISTRIBUTION_ID
2675: and apdist.po_distribution_id = pod.po_distribution_id

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

2743: /* Bug 6353803: Added the following for this bug. */
2744: AND (pa_nl_installed.is_nl_installed = 'N'
2745: OR ( pa_nl_installed.is_nl_installed = 'Y'
2746: AND NOT EXISTS (SELECT 'X'
2747: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2748: WHERE pod.po_distribution_id = dist.po_distribution_id
2749: AND pod.po_line_id = pol.po_line_id
2750: AND si.inventory_item_id = pol.item_id
2751: AND si.comms_nl_trackable_flag = 'Y'

Line 2763: mtl_system_items si,

2759: AND NOT EXISTS (SELECT 'X'
2760: FROM
2761: ap_invoice_distributions apdist,
2762: po_distributions pod,
2763: mtl_system_items si,
2764: po_lines_all pol
2765: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2766: = apdist.INVOICE_DISTRIBUTION_ID
2767: and apdist.po_distribution_id = pod.po_distribution_id

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

2826: AND aid.project_id = G_PROJECT_ID)
2827: AND (pa_nl_installed.is_nl_installed = 'N'
2828: OR ( pa_nl_installed.is_nl_installed = 'Y'
2829: AND NOT EXISTS (SELECT 'X'
2830: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2831: WHERE pod.po_distribution_id = dist.po_distribution_id
2832: AND pod.po_line_id = pol.po_line_id
2833: AND si.inventory_item_id = pol.item_id
2834: AND si.comms_nl_trackable_flag = 'Y'

Line 2846: mtl_system_items si,

2842: AND NOT EXISTS (SELECT 'X'
2843: FROM
2844: AP_SELF_ASSESSED_TAX_DIST_ALL apdist,
2845: po_distributions pod,
2846: mtl_system_items si,
2847: po_lines_all pol
2848: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2849: = apdist.INVOICE_DISTRIBUTION_ID
2850: and apdist.po_distribution_id = pod.po_distribution_id

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

2911: /* Bug 6353803: Added the following for this bug. */
2912: AND (pa_nl_installed.is_nl_installed = 'N'
2913: OR ( pa_nl_installed.is_nl_installed = 'Y'
2914: AND NOT EXISTS (SELECT 'X'
2915: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2916: WHERE pod.po_distribution_id = dist.po_distribution_id
2917: AND pod.po_line_id = pol.po_line_id
2918: AND si.inventory_item_id = pol.item_id
2919: AND si.comms_nl_trackable_flag = 'Y'

Line 2931: mtl_system_items si,

2927: AND NOT EXISTS (SELECT 'X'
2928: FROM
2929: ap_invoice_distributions apdist,
2930: po_distributions pod,
2931: mtl_system_items si,
2932: po_lines_all pol
2933: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
2934: = apdist.INVOICE_DISTRIBUTION_ID
2935: and apdist.po_distribution_id = pod.po_distribution_id

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

2992: )
2993: AND (pa_nl_installed.is_nl_installed = 'N'
2994: OR ( pa_nl_installed.is_nl_installed = 'Y'
2995: AND NOT EXISTS (SELECT 'X'
2996: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
2997: WHERE pod.po_distribution_id = dist.po_distribution_id
2998: AND pod.po_line_id = pol.po_line_id
2999: AND si.inventory_item_id = pol.item_id
3000: AND si.comms_nl_trackable_flag = 'Y'

Line 3012: mtl_system_items si,

3008: AND NOT EXISTS (SELECT 'X'
3009: FROM
3010: AP_SELF_ASSESSED_TAX_DIST apdist,
3011: po_distributions pod,
3012: mtl_system_items si,
3013: po_lines_all pol
3014: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
3015: = apdist.INVOICE_DISTRIBUTION_ID
3016: and apdist.po_distribution_id = pod.po_distribution_id

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

3095: /* Bug 6353803: Added the following for this bug. */
3096: AND (pa_nl_installed.is_nl_installed = 'N'
3097: OR ( pa_nl_installed.is_nl_installed = 'Y'
3098: AND NOT EXISTS (SELECT 'X'
3099: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
3100: WHERE pod.po_distribution_id = dist.po_distribution_id
3101: AND pod.po_line_id = pol.po_line_id
3102: AND si.inventory_item_id = pol.item_id
3103: AND si.comms_nl_trackable_flag = 'Y'

Line 3115: mtl_system_items si,

3111: AND NOT EXISTS (SELECT 'X'
3112: FROM
3113: ap_invoice_distributions apdist,
3114: po_distributions pod,
3115: mtl_system_items si,
3116: po_lines_all pol
3117: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
3118: = apdist.INVOICE_DISTRIBUTION_ID
3119: and apdist.po_distribution_id = pod.po_distribution_id

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

3186: /* Bug 6353803: Added the following for this bug. */
3187: AND (pa_nl_installed.is_nl_installed = 'N'
3188: OR ( pa_nl_installed.is_nl_installed = 'Y'
3189: AND NOT EXISTS (SELECT 'X'
3190: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
3191: WHERE pod.po_distribution_id = dist.po_distribution_id
3192: AND pod.po_line_id = pol.po_line_id
3193: AND si.inventory_item_id = pol.item_id
3194: AND si.comms_nl_trackable_flag = 'Y'

Line 3206: mtl_system_items si,

3202: AND NOT EXISTS (SELECT 'X'
3203: FROM
3204: ap_invoice_distributions apdist,
3205: po_distributions pod,
3206: mtl_system_items si,
3207: po_lines_all pol
3208: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
3209: = apdist.INVOICE_DISTRIBUTION_ID
3210: and apdist.po_distribution_id = pod.po_distribution_id

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

3267: AND aid.project_id > 0 )
3268: AND (pa_nl_installed.is_nl_installed = 'N'
3269: OR ( pa_nl_installed.is_nl_installed = 'Y'
3270: AND NOT EXISTS (SELECT 'X'
3271: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
3272: WHERE pod.po_distribution_id = dist.po_distribution_id
3273: AND pod.po_line_id = pol.po_line_id
3274: AND si.inventory_item_id = pol.item_id
3275: AND si.comms_nl_trackable_flag = 'Y'

Line 3287: mtl_system_items si,

3283: AND NOT EXISTS (SELECT 'X'
3284: FROM
3285: AP_SELF_ASSESSED_TAX_DIST_ALL apdist,
3286: po_distributions pod,
3287: mtl_system_items si,
3288: po_lines_all pol
3289: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
3290: = apdist.INVOICE_DISTRIBUTION_ID
3291: and apdist.po_distribution_id = pod.po_distribution_id

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

3353: /* Bug 6353803: Added the following for this bug. */
3354: AND (pa_nl_installed.is_nl_installed = 'N'
3355: OR ( pa_nl_installed.is_nl_installed = 'Y'
3356: AND NOT EXISTS (SELECT 'X'
3357: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
3358: WHERE pod.po_distribution_id = dist.po_distribution_id
3359: AND dist.po_distribution_id > 0 /*Added for bug#12922795 */
3360: AND pod.po_line_id = pol.po_line_id
3361: AND si.inventory_item_id = pol.item_id

Line 3374: mtl_system_items si,

3370: AND NOT EXISTS (SELECT 'X'
3371: FROM
3372: ap_invoice_distributions apdist,
3373: po_distributions pod,
3374: mtl_system_items si,
3375: po_lines_all pol
3376: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
3377: = apdist.INVOICE_DISTRIBUTION_ID
3378: and apdist.po_distribution_id = pod.po_distribution_id

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

3435: )
3436: AND (pa_nl_installed.is_nl_installed = 'N'
3437: OR ( pa_nl_installed.is_nl_installed = 'Y'
3438: AND NOT EXISTS (SELECT 'X'
3439: FROM po_distributions_all pod, mtl_system_items si, po_lines_all pol
3440: WHERE pod.po_distribution_id = dist.po_distribution_id
3441: AND pod.po_line_id = pol.po_line_id
3442: AND si.inventory_item_id = pol.item_id
3443: AND si.comms_nl_trackable_flag = 'Y'

Line 3455: mtl_system_items si,

3451: AND NOT EXISTS (SELECT 'X'
3452: FROM
3453: AP_SELF_ASSESSED_TAX_DIST apdist,
3454: po_distributions pod,
3455: mtl_system_items si,
3456: po_lines_all pol
3457: where DIST.CHARGE_APPLICABLE_TO_DIST_ID
3458: = apdist.INVOICE_DISTRIBUTION_ID
3459: and apdist.po_distribution_id = pod.po_distribution_id

Line 8982: FROM mtl_system_items si,

8978: WHERE inv.invoice_id = dist.invoice_id
8979: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
8980: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
8981: AND EXISTS (SELECT 'X'
8982: FROM mtl_system_items si,
8983: po_lines_all pol,
8984: po_distributions_all po_dist1
8985: WHERE po_dist1.po_line_id = pol.po_line_id
8986: AND po_dist1.po_distribution_id = dist.po_distribution_id

Line 9064: FROM mtl_system_items si,

9060: WHERE inv.invoice_id = dist.invoice_id
9061: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9062: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9063: AND EXISTS (SELECT 'X'
9064: FROM mtl_system_items si,
9065: po_lines_all pol,
9066: po_distributions_all po_dist1
9067: WHERE po_dist1.po_line_id = pol.po_line_id
9068: AND po_dist1.po_distribution_id = dist.po_distribution_id

Line 9203: FROM mtl_system_items si,

9199: WHERE inv.invoice_id = dist.invoice_id
9200: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9201: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9202: AND EXISTS (SELECT 'X'
9203: FROM mtl_system_items si,
9204: po_lines_all pol,
9205: po_distributions_all po_dist1
9206: WHERE po_dist1.po_line_id = pol.po_line_id
9207: AND po_dist1.po_distribution_id = dist.po_distribution_id

Line 9286: FROM mtl_system_items si,

9282: WHERE inv.invoice_id = dist.invoice_id
9283: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9284: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9285: AND EXISTS (SELECT 'X'
9286: FROM mtl_system_items si,
9287: po_lines_all pol,
9288: po_distributions_all po_dist1
9289: WHERE po_dist1.po_line_id = pol.po_line_id
9290: AND po_dist1.po_distribution_id = dist.po_distribution_id