[Home] [Help]
20: if (p_sub_inv IS NOT NULL ) then
21:
22: select mms.status_code
23: into x_status_code
24: from mtl_material_statuses mms ,
25: MTL_SECONDARY_INVENTORIES msi
26: where mms.status_id = msi.status_id
27: and msi.SECONDARY_INVENTORY_NAME = p_sub_inv
28: and msi.organization_id = p_org_id;
30: elsif (p_locator_id IS NOT NULL ) then
31:
32: select mms.status_code
33: into x_status_code
34: from mtl_material_statuses mms ,
35: MTL_ITEM_LOCATIONS_KFV mil
36: where mms.status_id = mil.status_id
37: and mil.INVENTORY_LOCATION_ID = p_locator_id
38: and mil.organization_id = p_org_id;
40: elsif (p_serial IS NOT NULL) then
41:
42: select mms.status_code
43: into x_status_code
44: from mtl_material_statuses mms ,
45: MTL_SERIAL_NUMBERS msn
46: where mms.status_id = msn.status_id
47: and msn.SERIAL_NUMBER = p_serial
48: and msn.current_organization_id = p_org_id
51: elsIF (p_lot IS NOT NULL) then
52:
53: select mms.status_code
54: into x_status_code
55: from mtl_material_statuses mms ,
56: MTL_LOT_NUMBERS mln
57: where mms.status_id = mln.status_id
58: and mln.LOT_NUMBER = p_lot
59: and mln.organization_id = p_org_id
158: end if;
159: if x_Status = 'C' then
160: SELECT status_code
161: INTO x_status_code
162: FROM MTL_MATERIAL_STATUSES_VL
163: WHERE status_id = lot_status_id;
164: end if;
165:
166: END check_lot_range_status;
240:
241: if x_Status = 'C' then
242: SELECT status_code
243: INTO x_status_code
244: FROM MTL_MATERIAL_STATUSES_VL
245: WHERE status_id = serial_status_id;
246: end if;
247:
248: END check_serial_range_status;
482: ---lpn status project start for updating full lpn case
483: IF (p_lpn_id IS NOT NULL AND p_inventory_item_id IS NULL)THEN
484: --bug 6952533
485: SELECT serial_control into l_serial_status_control
486: from mtl_material_statuses
487: WHERE status_id = p_onhand_status_id;
488: --end of bug 6952533
489: IF(l_allow_mixed_status = 2)THEN
490: SELECT outermost_lpn_id into l_outermost_lpn_id
624: mdebug(' update executed in sql: Onhand');
625:
626: -- Added the serial status check for bug # 7113129
627: SELECT serial_control into l_serial_status_control
628: from mtl_material_statuses
629: WHERE status_id = p_onhand_status_id;
630:
631: IF (l_serial_status_control = 1) THEN
632: OPEN cur_onhserial;
849: WHERE REASON_ID = p_sub_reason_id;
850:
851: SELECT status_code
852: INTO l_status_code
853: FROM MTL_MATERIAL_STATUSES_VL
854: WHERE status_id = p_sub_status_id;
855:
856: IF (l_debug = 1) THEN
857: mdebug('l_workflow_name: '||l_workflow_name);
906: WHERE REASON_ID = p_loc_reason_id;
907:
908: SELECT status_code
909: INTO l_status_code
910: FROM MTL_MATERIAL_STATUSES_VL
911: WHERE status_id = p_loc_status_id;
912:
913: if l_workflow_name is not null THEN
914:
957: WHERE REASON_ID = p_lot_reason_id;
958:
959: SELECT status_code
960: INTO l_status_code
961: FROM MTL_MATERIAL_STATUSES_VL
962: WHERE status_id = p_lot_status_id;
963:
964: if l_workflow_name is not null then
965: wms_workflow_wrappers.wf_start_workflow
1010: WHERE REASON_ID = p_serial_reason_id;
1011:
1012: SELECT status_code
1013: INTO l_status_code
1014: FROM MTL_MATERIAL_STATUSES_VL
1015: WHERE status_id = p_serial_status_id;
1016:
1017: if l_workflow_name is not null then
1018: wms_workflow_wrappers.wf_start_workflow
1067: WHERE REASON_ID = p_onhand_reason_id;
1068:
1069: SELECT status_code
1070: INTO l_status_code
1071: FROM MTL_MATERIAL_STATUSES_VL
1072: WHERE status_id = p_onhand_status_id;
1073:
1074: IF (l_debug = 1) THEN
1075: mdebug('l_workflow_name: '||l_workflow_name);