APPS.INV_RCV_RESERVATION_UTIL dependencies on RCV_SHIPMENT_LINES

Line 1064: FROM rcv_shipment_lines

1060: l_progress := '@@@';
1061: BEGIN
1062: SELECT 1
1063: INTO l_dummy
1064: FROM rcv_shipment_lines
1065: WHERE shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
1066: FOR UPDATE NOWAIT;
1067: EXCEPTION
1068: WHEN OTHERS THEN

Line 1263: FROM rcv_shipment_lines

1259: l_progress := '###';
1260: BEGIN
1261: SELECT 1
1262: INTO l_dummy
1263: FROM rcv_shipment_lines
1264: WHERE shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
1265: FOR UPDATE NOWAIT;
1266: EXCEPTION
1267: WHEN OTHERS THEN

Line 1318: FROM rcv_shipment_lines

1314:
1315: l_progress := '###';
1316: SELECT 1
1317: INTO l_dummy
1318: FROM rcv_shipment_lines
1319: WHERE requisition_line_id = p_cas_mol_rec_tb(1).requisition_line_id
1320: AND shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
1321:
1322: FOR UPDATE NOWAIT;

Line 1346: FROM rcv_shipment_lines

1342: l_progress := '###';
1343: BEGIN
1344: SELECT shipment_header_id
1345: INTO l_shipment_header_id
1346: FROM rcv_shipment_lines
1347: WHERE shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
1348: FOR UPDATE NOWAIT;
1349: EXCEPTION
1350: WHEN OTHERS THEN

Line 2516: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl

2512:
2513: BEGIN
2514: SELECT rsh.receipt_source_code
2515: INTO l_receipt_source_code
2516: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl
2517: WHERE rsl.shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
2518: AND rsl.shipment_header_id = rsh.shipment_header_id;
2519: EXCEPTION
2520: WHEN no_data_found THEN

Line 2560: FROM rcv_shipment_lines

2556: ELSIF (l_receipt_source_code = 'INVENTORY') THEN
2557: BEGIN
2558: SELECT shipment_header_id
2559: INTO l_shipment_header_id
2560: FROM rcv_shipment_lines
2561: WHERE shipment_line_id = p_cas_mol_rec_tb(1).shipment_line_id
2562: FOR UPDATE NOWAIT;
2563: EXCEPTION
2564: WHEN OTHERS THEN