APPS.PO_MULTI_MOD_VALIDATIONS dependencies on RCV_SHIPMENT_LINES

Line 3374: FROM rcv_shipment_lines

3370:
3371: BEGIN
3372: SELECT shipment_line_id
3373: BULK COLLECT INTO l_shipment_line_id_tbl
3374: FROM rcv_shipment_lines
3375: WHERE po_header_id = p_document_id_tbl(i);
3376: EXCEPTION
3377: WHEN no_data_found THEN
3378: l_shipment_line_id_tbl := null;

Line 3400: FROM rcv_shipment_lines rcvl

3396: ,Min(rt.transaction_date)
3397: INTO l_shipment_header_id
3398: ,l_receipt_num
3399: ,l_receipt_date
3400: FROM rcv_shipment_lines rcvl
3401: ,rcv_shipment_headers rcvh
3402: , rcv_transactions rt
3403: WHERE rcvl.shipment_header_id = rcvh.shipment_header_id
3404: AND rt.shipment_header_id = rcvh.shipment_header_id

Line 3412: FROM rcv_shipment_lines rsl,

3408: rcvh.receipt_num;
3409:
3410: SELECT Nvl(Sum(Nvl(rsl.quantity_received, 0) * NVL(poll.price_override, pol.unit_price) ), 0)
3411: INTO l_receipt_amount
3412: FROM rcv_shipment_lines rsl,
3413: po_line_locations_all poll,
3414: po_lines_all pol
3415: WHERE rsl.po_line_location_id = poll.line_location_id
3416: AND rsl.po_line_id = pol.po_line_id

Line 3424: FROM rcv_shipment_lines rsl

3420:
3421: IF l_receipt_amount = 0 THEN
3422: SELECT Nvl(Sum(Nvl(rsl.amount_received, 0)), 0)
3423: INTO l_receipt_amount
3424: FROM rcv_shipment_lines rsl
3425: WHERE rsl.quantity_shipped IS NULL
3426: AND rsl.shipment_line_id = l_shipment_line_id_tbl(i);
3427: END IF;
3428: