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 PO_LINES_ALL

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 2672: po_lines_all pol

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
2676: and pod.po_line_id = pol.po_line_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 2764: po_lines_all pol

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
2768: and pod.po_line_id = pol.po_line_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 2847: po_lines_all pol

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
2851: and pod.po_line_id = pol.po_line_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 2932: po_lines_all pol

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
2936: and pod.po_line_id = pol.po_line_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 3013: po_lines_all pol

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
3017: and pod.po_line_id = pol.po_line_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 3116: po_lines_all pol

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
3120: and pod.po_line_id = pol.po_line_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 3207: po_lines_all pol

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
3211: and pod.po_line_id = pol.po_line_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 3288: po_lines_all pol

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
3292: and pod.po_line_id = pol.po_line_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 3375: po_lines_all pol

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
3379: AND apdist.po_distribution_id > 0 /*Added for bug#12922795 */

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 3456: po_lines_all pol

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
3460: and pod.po_line_id = pol.po_line_id

Line 6925: po_lines_all POL

6921: WHERE exists
6922: (SELECT 1 --rcv_sub1.ROWID --Removed /*+ leading(po_dist) */ for Bug5262594
6923: FROM Rcv_Transactions rcv_txn,
6924: PO_Distributions po_dist,
6925: po_lines_all POL
6926: WHERE ((rcv_txn.destination_type_code ='EXPENSE' )
6927: OR (rcv_txn.destination_type_code = 'RECEIVING'
6928: AND (rcv_txn.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING'))))
6929: AND trunc(rcv_txn.transaction_date) <= trunc(nvl(G_GL_DATE,rcv_txn.transaction_date)) /*Added trunc for the bug 6623163 */

Line 7010: po_lines_all POL

7006: WHERE exists
7007: (SELECT 1 --rcv_sub1.ROWID --Removed /*+ leading(po_dist) */ for Bug5262594
7008: FROM Rcv_Transactions rcv_txn,
7009: PO_Distributions po_dist ,
7010: po_lines_all POL
7011: WHERE
7012: ((rcv_txn.destination_type_code ='EXPENSE' )
7013: OR (rcv_txn.destination_type_code = 'RECEIVING'
7014: AND (rcv_txn.transaction_type IN ('RETURN TO VENDOR','RETURN TO RECEIVING'))))

Line 8674: (SELECT 1 from rcv_transactions rcv_txn , po_lines_all pol WHERE

8670: AND (rcv_sub.accounting_event_id = l_rcv_acct_evt_id_tbl(i) OR rcv_sub.accounting_event_id IS NULL)
8671: AND rcv_sub.code_combination_id = l_dr_ccid_tbl(i)
8672: /* Start added for bug#6015451 */
8673: AND EXISTS
8674: (SELECT 1 from rcv_transactions rcv_txn , po_lines_all pol WHERE
8675: rcv_txn.transaction_id = l_sys_ref4_tbl(i)
8676: and rcv_txn.PO_line_ID = POL.po_line_id
8677: AND ( (rcv_txn.destination_type_code = 'EXPENSE' AND /*Starts-code changes for bug:9196652 */
8678: (( rcv_txn.transaction_type = 'DELIVER' AND

Line 8983: po_lines_all pol,

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
8987: AND si.inventory_item_id = pol.item_id

Line 9065: po_lines_all pol,

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
9069: AND si.inventory_item_id = pol.item_id

Line 9204: po_lines_all pol,

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
9208: AND si.inventory_item_id = pol.item_id

Line 9287: po_lines_all pol,

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
9291: AND si.inventory_item_id = pol.item_id