[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;
1102: into
1103: l_acq_cost_ent_po
1104: from
1105: cst_rcv_acq_cost_details cracd,
1106: po_line_locations_all poll,
1107: rcv_transactions rt
1108: where
1109: poll.line_location_id = cracd.po_line_location_id
1110: and cracd.header_id = (select header_id
1326: 'QUANTITY',POD.QUANTITY_ORDERED*l_uom_ratio) ) "TAX"
1327: -----------------------------------------------------------------------------------------
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
1377: INTO
1378: l_po_price
1379: FROM
1380: rcv_transactions rt,
1381: po_line_locations_all poll
1382: WHERE
1383: rt.transaction_id = i_ae_txn_rec.transaction_id
1384: AND rt.po_line_location_id = poll.line_location_id;
1385:
2441: 'QUANTITY',POD.QUANTITY_ORDERED*l_uom_ratio) "TAX"
2442: ---------------------------------------------------------------------------------------------------
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
2479: INTO
2480: l_po_price
2481: FROM
2482: rcv_transactions rt,
2483: po_line_locations_all poll
2484: WHERE
2485: rt.transaction_id = i_ae_txn_rec.transaction_id
2486: AND rt.po_line_location_id = poll.line_location_id;
2487:
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
2854: POH.po_header_id = POD.po_header_id AND
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
2891: POH.po_header_id = POD.po_header_id
3548: pod.quantity_ordered)) "UNIT_PRICE",
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: (
4153: 'AMOUNT', rt6.AMOUNT,
4154: 'QUANTITY', RT6.PRIMARY_QUANTITY) "PRIMARY_QUANTITY"
4155: INTO l_primary_quantity
4156: FROM rcv_transactions rt6,
4157: PO_LINE_LOCATIONS_ALL POLL1 -- Changed for Complex work procurement
4158: WHERE rt6.transaction_id=c_nqd_rec.transaction_id
4159: AND RT6.PO_LINE_LOCATION_ID= POLL1.LINE_LOCATION_ID; -- Changed for Complex work procurement
4160: -- End of Bug 3588765 ----------------------
4161: