APPS.INV_RCV_COMMON_APIS dependencies on RCV_SHIPMENT_HEADERS

Line 386: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh, mtl_system_items msi1, mtl_system_items msi2

382: AND ROWNUM = 1;
383: ELSIF p_shipment_header_id IS NOT NULL THEN
384: SELECT 'N'
385: INTO l_lot_ser_flag
386: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh, mtl_system_items msi1, mtl_system_items msi2
387: WHERE rsh.shipment_header_id = p_shipment_header_id
388: AND rsl.shipment_header_id = rsh.shipment_header_id
389: AND rsl.item_id = msi1.inventory_item_id
390: AND msi1.organization_id = rsl.from_organization_id

Line 1362: FROM rcv_shipment_headers rsh

1358:
1359: BEGIN
1360: SELECT 1
1361: INTO l_receipt_exists
1362: FROM rcv_shipment_headers rsh
1363: WHERE receipt_num = x_receipt_num
1364: AND ship_to_org_id = p_organization_id;
1365: EXCEPTION
1366: WHEN NO_DATA_FOUND THEN

Line 1396: FROM rcv_shipment_headers rsh

1392:
1393: LOOP
1394: SELECT COUNT(1)
1395: INTO l_receipt_exists
1396: FROM rcv_shipment_headers rsh
1397: WHERE rsh.receipt_num = l_temp_rcpt_num
1398: AND rsh.ship_to_org_id = p_organization_id ;
1399:
1400: IF l_receipt_exists = 0 THEN

Line 7408: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh

7404: END IF;
7405:
7406: BEGIN
7407: SELECT 1 INTO x_count_of_lpns
7408: FROM wms_license_plate_numbers wlpn1, rcv_shipment_headers rsh
7409: WHERE rsh.shipment_num = p_shipment_num
7410: AND wlpn1.source_name = rsh.shipment_num
7411: AND ((wlpn1.lpn_context = 6 AND wlpn1.organization_id = rsh.organization_id) OR
7412: (wlpn1.lpn_context = 7 AND wlpn1.organization_id = rsh.ship_to_org_id))