[Home] [Help]
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
259: AND poll.line_location_id = rt.po_line_location_id; -- Added for Complex work procurement
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
438: poll.line_location_id = rae.po_line_location_id AND-- Added for Complex work procurement
737: into l_debit_acct_id, l_credit_acct_id,
738: l_po_dist_id,
739: l_unit_price
740: from rcv_accounting_events rae,
741: PO_LINE_LOCATIONS_ALL POLL -- Changed for Complex work procurement
742: where rae.accounting_event_id = i_ae_txn_rec.transaction_id
743: and RAE.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID; -- Changed for Complex work procurement
744:
745: l_ae_line_rec.actual_flag := NULL;
1088: into
1089: l_acq_cost_ent_po
1090: from
1091: cst_rcv_acq_cost_details cracd,
1092: po_line_locations_all poll,
1093: rcv_transactions rt
1094: where
1095: poll.line_location_id = cracd.po_line_location_id
1096: and cracd.header_id = (select header_id
1299: 'QUANTITY',POD.QUANTITY_ORDERED) ) "TAX"
1300: -----------------------------------------------------------------------------------------
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
1350: INTO
1351: l_po_price
1352: FROM
1353: rcv_transactions rt,
1354: po_line_locations_all poll
1355: WHERE
1356: rt.transaction_id = i_ae_txn_rec.transaction_id
1357: AND rt.po_line_location_id = poll.line_location_id;
1358:
2161: 'QUANTITY',POD.QUANTITY_ORDERED) "TAX"
2162: ---------------------------------------------------------------------------------------------------
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
2199: INTO
2200: l_po_price
2201: FROM
2202: rcv_transactions rt,
2203: po_line_locations_all poll
2204: WHERE
2205: rt.transaction_id = i_ae_txn_rec.transaction_id
2206: AND rt.po_line_location_id = poll.line_location_id;
2207:
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
2494: POH.po_header_id = POD.po_header_id AND
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
2531: POH.po_header_id = POD.po_header_id
3188: pod.quantity_ordered)) "UNIT_PRICE",
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: (
3771: 'AMOUNT', rt6.AMOUNT,
3772: 'QUANTITY', RT6.PRIMARY_QUANTITY) "PRIMARY_QUANTITY"
3773: INTO l_primary_quantity
3774: FROM rcv_transactions rt6,
3775: PO_LINE_LOCATIONS_ALL POLL1 -- Changed for Complex work procurement
3776: WHERE rt6.transaction_id=c_nqd_rec.transaction_id
3777: AND RT6.PO_LINE_LOCATION_ID= POLL1.LINE_LOCATION_ID; -- Changed for Complex work procurement
3778: -- End of Bug 3588765 ----------------------
3779: