APPS.INV_RCV_STD_INSPECT_APIS dependencies on RCV_SHIPMENT_LINES

Line 3400: ,rcv_shipment_lines rsl

3396: , l_customer_site_id
3397: , l_customer_item_number
3398: FROM rcv_supply rsup
3399: ,rcv_shipment_headers rsh
3400: ,rcv_shipment_lines rsl
3401: ,rcv_transactions rt
3402: ,po_line_locations pll
3403: ,po_lines pol
3404: ,mtl_system_items msi

Line 3816: FROM rcv_shipment_lines

3812: IF nvl(v_lcm_enabled_org, 'N') = 'Y' THEN
3813:
3814: SELECT LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST
3815: INTO v_lcm_ship_line_id, v_unit_landed_cost
3816: FROM rcv_shipment_lines
3817: WHERE shipment_line_id = l_shipment_line_id;
3818:
3819: UPDATE rcv_transactions_interface
3820: SET lcm_shipment_line_id = v_lcm_ship_line_id,

Line 4804: FROM mtl_txn_request_lines mtrl, rcv_shipment_lines rsl

4800:
4801: -- obtain SHIPMENT RECEIPT INFORMATION
4802: SELECT COUNT(DISTINCT rsl.shipment_header_id)
4803: INTO v_count_intshp
4804: FROM mtl_txn_request_lines mtrl, rcv_shipment_lines rsl
4805: WHERE reference = 'SHIPMENT_LINE_ID'
4806: AND mtrl.reference_id = rsl.shipment_line_id
4807: AND mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
4808: AND mtrl.lpn_id = p_lpn_id

Line 4824: from mtl_txn_request_lines mtrl, rcv_shipment_lines rsl, rcv_shipment_headers rsh

4820: x_msg_data := ' ';
4821:
4822: select distinct rsl.shipment_header_id, rsh.shipment_num, rsh.receipt_num
4823: into x_intshp_id, x_intshp_number, x_receipt_number
4824: from mtl_txn_request_lines mtrl, rcv_shipment_lines rsl, rcv_shipment_headers rsh
4825: where reference = 'SHIPMENT_LINE_ID'
4826: and mtrl.quantity > nvl(mtrl.quantity_delivered, 0)
4827: and mtrl.reference_id = rsl.shipment_line_id
4828: and rsl.shipment_header_id = rsh.shipment_header_id