DBA Data[Home] [Help]

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 1332: PO_LINES_ALL POL,

1328: FROM
1329: po_distributions_all pod,
1330: po_line_locations_all poll,
1331: -- J Changes ----------------------------------------------------------------------------
1332: PO_LINES_ALL POL,
1333: -----------------------------------------------------------------------------------------
1334: rcv_parameters rp
1335: WHERE
1336: -- begin fix for perf bug 2581067

Line 2447: PO_LINES_ALL POL,

2443: FROM
2444: po_distributions_all pod,
2445: po_line_locations_all poll,
2446: -- J Changes --------------------------------------------------------------------------------------
2447: PO_LINES_ALL POL,
2448: ---------------------------------------------------------------------------------------------------
2449: rcv_parameters rp
2450: WHERE
2451: -- begin fix for perf bug 2581067

Line 2849: po_lines_all POL,

2845: l_po_rate,
2846: l_po_rate_date
2847: FROM
2848: po_headers_all POH,
2849: po_lines_all POL,
2850: po_line_locations_all POLL,
2851: po_distributions_all POD,
2852: rcv_transactions RT
2853: WHERE

Line 2886: po_lines_all POL,

2882: l_po_rate,
2883: l_po_rate_date
2884: FROM
2885: po_headers_all POH,
2886: po_lines_all POL,
2887: po_line_locations_all POLL,
2888: po_distributions_all POD,
2889: rcv_transactions RT
2890: WHERE

Line 3553: po_lines_all pol,

3549: NVL(poll.match_option,'P') "MATCH_OPTION"
3550: FROM
3551: po_distributions_all pod,
3552: po_line_locations_all poll,
3553: po_lines_all pol,
3554: rcv_parameters rp
3555: WHERE
3556: (
3557: (l_doc_level = 'D' AND pod.po_distribution_id = l_doc_id)

Line 4117: -- PO_LINES_ALL POL

4113: FROM
4114: rcv_transactions rt4
4115: -- J Changes -------------------------------------------------------------
4116: -- Bug 3588765 --
4117: -- PO_LINES_ALL POL
4118: -- End of Bug 3588765
4119: --------------------------------------------------------------------------
4120: WHERE
4121: rt4.transaction_id < i_transaction_id

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

4120: WHERE
4121: rt4.transaction_id < i_transaction_id
4122: -- J Changes -------------------------------------------------------------
4123: -- Bug 3588765 --
4124: AND EXISTS (SELECT 1 FROM PO_LINES_ALL POL WHERE RT4.PO_LINE_ID= POL.PO_LINE_ID)
4125: -- AND RT4.PO_LINE_ID = POL.PO_LINE_ID
4126: -- End of Bug 3588765
4127: --------------------------------------------------------------------------
4128: START WITH