APPS.CSTPAPPR dependencies on PO_LINES_ALL

Line 167: po_lines_all pol,

163: count(rt.po_line_id) -- change for the bug 4968702
164: INTO
165: l_po_line_count
166: FROM
167: po_lines_all pol,
168: rcv_transactions rt
169: WHERE
170: pol.po_line_id = rt.po_line_id AND
171: rt.transaction_id = i_transaction_id;

Line 254: po_lines_all pol,

250: l_ae_txn_rec.line_id,
251: l_ae_txn_rec.lcm_flag
252: FROM
253: rcv_transactions rt,
254: po_lines_all pol,
255: po_line_locations_all poll -- Added for Complex work procurement
256: WHERE
257: rt.po_line_id = pol.po_line_id
258: AND rt.transaction_id = i_transaction_id

Line 343: po_lines_all pol,

339: count(*)
340: INTO
341: l_po_line_count
342: FROM
343: po_lines_all pol,
344: rcv_transactions rt,
345: rcv_accounting_events rae
346: WHERE
347: pol.po_line_id = rt.po_line_id AND

Line 433: po_lines_all pol,

429: l_ae_txn_rec.exp_item ,
430: l_ae_txn_rec.line_id
431: FROM
432: rcv_accounting_events rae,
433: po_lines_all pol,
434: po_line_locations_all poll -- Added for Complex work procurement
435: WHERE
436: pol.po_line_id = RAE.PO_LINE_ID AND
437: poll.po_line_id = pol.po_line_id AND

Line 1305: PO_LINES_ALL POL,

1301: FROM
1302: po_distributions_all pod,
1303: po_line_locations_all poll,
1304: -- J Changes ----------------------------------------------------------------------------
1305: PO_LINES_ALL POL,
1306: -----------------------------------------------------------------------------------------
1307: rcv_parameters rp
1308: WHERE
1309: -- begin fix for perf bug 2581067

Line 2167: PO_LINES_ALL POL,

2163: FROM
2164: po_distributions_all pod,
2165: po_line_locations_all poll,
2166: -- J Changes --------------------------------------------------------------------------------------
2167: PO_LINES_ALL POL,
2168: ---------------------------------------------------------------------------------------------------
2169: rcv_parameters rp
2170: WHERE
2171: -- begin fix for perf bug 2581067

Line 2489: po_lines_all POL,

2485: l_po_rate,
2486: l_po_rate_date
2487: FROM
2488: po_headers_all POH,
2489: po_lines_all POL,
2490: po_line_locations_all POLL,
2491: po_distributions_all POD,
2492: rcv_transactions RT
2493: WHERE

Line 2526: po_lines_all POL,

2522: l_po_rate,
2523: l_po_rate_date
2524: FROM
2525: po_headers_all POH,
2526: po_lines_all POL,
2527: po_line_locations_all POLL,
2528: po_distributions_all POD,
2529: rcv_transactions RT
2530: WHERE

Line 3193: po_lines_all pol,

3189: NVL(poll.match_option,'P') "MATCH_OPTION"
3190: FROM
3191: po_distributions_all pod,
3192: po_line_locations_all poll,
3193: po_lines_all pol,
3194: rcv_parameters rp
3195: WHERE
3196: (
3197: (l_doc_level = 'D' AND pod.po_distribution_id = l_doc_id)

Line 3735: -- PO_LINES_ALL POL

3731: FROM
3732: rcv_transactions rt4
3733: -- J Changes -------------------------------------------------------------
3734: -- Bug 3588765 --
3735: -- PO_LINES_ALL POL
3736: -- End of Bug 3588765
3737: --------------------------------------------------------------------------
3738: WHERE
3739: rt4.transaction_id < i_transaction_id

Line 3742: AND EXISTS (SELECT 1 FROM PO_LINES_ALL POL WHERE RT4.PO_LINE_ID= POL.PO_LINE_ID)

3738: WHERE
3739: rt4.transaction_id < i_transaction_id
3740: -- J Changes -------------------------------------------------------------
3741: -- Bug 3588765 --
3742: AND EXISTS (SELECT 1 FROM PO_LINES_ALL POL WHERE RT4.PO_LINE_ID= POL.PO_LINE_ID)
3743: -- AND RT4.PO_LINE_ID = POL.PO_LINE_ID
3744: -- End of Bug 3588765
3745: --------------------------------------------------------------------------
3746: START WITH