1346: -- OPMConvergence
1347: ,l_sec_lot_qty
1348: -- OPMConvergence
1349: FROM
1350: rcv_lots_supply
1351: WHERE
1352: shipment_line_id = p_shipment_line_id
1353: AND supply_type_code = 'SHIPMENT'
1354: GROUP BY lot_num;
1593: AND supply_type_code = 'SHIPMENT';
1594:
1595: SELECT Count(*)
1596: INTO l_lots_count
1597: FROM rcv_lots_supply
1598: WHERE shipment_line_id = p_shipment_line_id
1599: AND supply_type_code = 'SHIPMENT';
1600:
1601: IF (l_debug = 1) THEN
1630: END IF;
1631:
1632: IF l_lots_count > 0 THEN
1633:
1634: DELETE FROM rcv_lots_supply
1635: WHERE shipment_line_id = p_shipment_line_id
1636: AND supply_type_code = 'SHIPMENT';
1637:
1638: END IF;
11232: , NULL) inspection_status
11233: , rt.project_id project_id
11234: , rt.task_id task_id
11235: FROM rcv_supply rs
11236: , rcv_lots_supply rls
11237: , rcv_transactions rt
11238: WHERE rs.lpn_id = v_lpn_id
11239: AND rs.rcv_transaction_id = rls.transaction_id (+)
11240: AND rs.supply_type_code = 'RECEIVING'
17222: l_dummy VARCHAR2(1);
17223: BEGIN
17224: SELECT '1'
17225: INTO l_dummy
17226: FROM rcv_lots_supply
17227: WHERE transaction_id = p_parent_txn_id
17228: AND ROWNUM = 1;
17229:
17230: RETURN TRUE;
18642: * So, added nvl for the SUM(rls.primary_quantity).
18643: */
18644: SELECT nvl(SUM(rls.primary_quantity),0)--Bug:5489462
18645: INTO L_RLS_PRIMARY_QUANTITY
18646: FROM rcv_lots_supply rls
18647: , rcv_shipment_lines rsl
18648: WHERE rsl.SHIPMENT_LINE_ID = rls.SHIPMENT_LINE_ID
18649: AND rsl.shipment_header_id = l_shipment_header_id
18650: AND rsl.item_id = l_item_id
18804: -- INVCONV , Remove sublot_num. Punit Kumar
18805:
18806: SELECT primary_quantity
18807: INTO l_rls_primary_quantity
18808: FROM rcv_lots_supply
18809: WHERE transaction_id = l_parent_transaction_id
18810: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number)) ;
18811: /*
18812: AND ((sublot_num IS NULL and Ltrim(Rtrim(l_mtlt_rec.sublot_num)) IS NULL)
18939: IF (L_FROM_ORG_LOT_CTRL = 2) THEN
18940: BEGIN
18941: SELECT nvl(SUM(rls.primary_quantity),0) --Bug:5489462
18942: INTO L_RLS_PRIMARY_QUANTITY
18943: FROM rcv_lots_supply rls
18944: , rcv_shipment_lines rsl
18945: WHERE rls.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
18946: AND rsl.shipment_header_id = l_shipment_header_id
18947: AND rsl.item_id = l_item_id
23172: /*INVCONV, Remove the sublot no check in SQL, Punit Kumar */
23173:
23174: SELECT primary_quantity
23175: INTO l_rls_primary_quantity
23176: FROM rcv_lots_supply
23177: WHERE transaction_id = l_great_grand_parent_txn_id
23178: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number)) ;
23179:
23180: /*
23328: /* INVCONV , Remove Sublot Num from SQL , Punit Kumar*/
23329:
23330: SELECT primary_quantity
23331: INTO l_rls_primary_quantity
23332: FROM rcv_lots_supply
23333: WHERE transaction_id = l_parent_transaction_id
23334: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number));
23335:
23336: /*
25984: /* INVCONV, Remove sublot Num , Punit Kumar */
25985:
25986: SELECT primary_quantity
25987: INTO l_rls_primary_quantity
25988: FROM rcv_lots_supply
25989: WHERE transaction_id = l_grand_parent_txn_id
25990: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number)) ;
25991:
25992: /*
26220: /*INVCONV , Remove Sublot Num , Punit Kumar*/
26221:
26222: SELECT primary_quantity
26223: INTO l_rls_primary_quantity
26224: FROM rcv_lots_supply
26225: WHERE transaction_id = l_grand_parent_txn_id
26226: AND lot_num = Ltrim(Rtrim(l_mtlt_rec.lot_number));
26227: /*
26228: AND ((sublot_num IS NULL and Ltrim(Rtrim(l_mtlt_rec.sublot_num)) IS NULL)
26262: IF (L_FROM_ORG_LOT_CTRL = 2) THEN
26263: BEGIN
26264: SELECT nvl(SUM(rls.primary_quantity),0) --Bug:5489462
26265: INTO L_RLS_PRIMARY_QUANTITY
26266: FROM rcv_lots_supply rls
26267: , rcv_shipment_lines rsl
26268: WHERE rsl.SHIPMENT_LINE_ID = rls.SHIPMENT_LINE_ID
26269: AND rsl.shipment_header_id = l_shipment_header_id
26270: AND rsl.item_id = l_item_id