APPS.INV_RCV_RESERVATION_UTIL dependencies on RCV_SHIPMENT_LINES

Line 1102: FROM rcv_shipment_lines

1098: l_progress := '@@@';
1099: BEGIN
1100: SELECT 1
1101: INTO l_dummy
1102: FROM rcv_shipment_lines
1103: WHERE shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
1104: FOR UPDATE NOWAIT;
1105: EXCEPTION
1106: WHEN OTHERS THEN

Line 1308: FROM rcv_shipment_lines

1304: l_progress := '###';
1305: BEGIN
1306: SELECT 1
1307: INTO l_dummy
1308: FROM rcv_shipment_lines
1309: WHERE shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
1310: FOR UPDATE NOWAIT;
1311: EXCEPTION
1312: WHEN OTHERS THEN

Line 1363: FROM rcv_shipment_lines

1359:
1360: l_progress := '###';
1361: SELECT 1
1362: INTO l_dummy
1363: FROM rcv_shipment_lines
1364: WHERE requisition_line_id = p_cas_mol_rec_tb(1).requisition_line_id
1365: AND shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
1366:
1367: FOR UPDATE NOWAIT;

Line 1391: FROM rcv_shipment_lines

1387: l_progress := '###';
1388: BEGIN
1389: SELECT shipment_header_id
1390: INTO l_shipment_header_id
1391: FROM rcv_shipment_lines
1392: WHERE shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
1393: FOR UPDATE NOWAIT;
1394: EXCEPTION
1395: WHEN OTHERS THEN

Line 2722: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl

2718:
2719: BEGIN
2720: SELECT rsh.receipt_source_code
2721: INTO l_receipt_source_code
2722: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl
2723: WHERE rsl.shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
2724: AND rsl.shipment_header_id = rsh.shipment_header_id;
2725: EXCEPTION
2726: WHEN no_data_found THEN

Line 2766: FROM rcv_shipment_lines

2762: ELSIF (l_receipt_source_code = 'INVENTORY') THEN
2763: BEGIN
2764: SELECT shipment_header_id
2765: INTO l_shipment_header_id
2766: FROM rcv_shipment_lines
2767: WHERE shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
2768: FOR UPDATE NOWAIT;
2769: EXCEPTION
2770: WHEN OTHERS THEN