[Home] [Help]
41: if (p_sub_inv IS NOT NULL ) then
42:
43: select mms.status_code
44: into x_status_code
45: from mtl_material_statuses mms ,
46: MTL_SECONDARY_INVENTORIES msi
47: where mms.status_id = msi.status_id
48: and msi.SECONDARY_INVENTORY_NAME = p_sub_inv
49: and msi.organization_id = p_org_id;
51: elsif (p_locator_id IS NOT NULL ) then
52:
53: select mms.status_code
54: into x_status_code
55: from mtl_material_statuses mms ,
56: MTL_ITEM_LOCATIONS_KFV mil
57: where mms.status_id = mil.status_id
58: and mil.INVENTORY_LOCATION_ID = p_locator_id
59: and mil.organization_id = p_org_id;
61: elsif (p_serial IS NOT NULL) then
62:
63: select mms.status_code
64: into x_status_code
65: from mtl_material_statuses mms ,
66: MTL_SERIAL_NUMBERS msn
67: where mms.status_id = msn.status_id
68: and msn.SERIAL_NUMBER = p_serial
69: and msn.current_organization_id = p_org_id
72: elsIF (p_lot IS NOT NULL) then
73:
74: select mms.status_code
75: into x_status_code
76: from mtl_material_statuses mms ,
77: MTL_LOT_NUMBERS mln
78: where mms.status_id = mln.status_id
79: and mln.LOT_NUMBER = p_lot
80: and mln.organization_id = p_org_id
117: BEGIN
118: mdebug('Item is not serial controlled');
119: select mms.status_code
120: into x_status_code
121: from mtl_material_statuses mms ,
122: mtl_onhand_quantities_detail moqd
123: where mms.status_id = moqd.status_id
124: and moqd.organization_id = p_org_id
125: and moqd.inventory_item_id = p_item_id
214: end if;
215: if x_Status = 'C' then
216: SELECT status_code
217: INTO x_status_code
218: FROM MTL_MATERIAL_STATUSES_VL
219: WHERE status_id = lot_status_id;
220: end if;
221:
222: END check_lot_range_status;
296:
297: if x_Status = 'C' then
298: SELECT status_code
299: INTO x_status_code
300: FROM MTL_MATERIAL_STATUSES_VL
301: WHERE status_id = serial_status_id;
302: end if;
303:
304: END check_serial_range_status;
429: mdebug(' update executed in sql: Onhand');
430:
431: -- Added the serial status check for bug # 7113129
432: SELECT serial_control into l_serial_status_control
433: from mtl_material_statuses
434: WHERE status_id = p_status_id;
435:
436: IF (l_serial_status_control = 1) THEN
437: OPEN cur_onhserial;
1005: ---lpn status project start for updating full lpn case
1006: IF (p_lpn_id IS NOT NULL AND p_inventory_item_id IS NULL)THEN
1007: --bug 6952533
1008: SELECT serial_control into l_serial_status_control
1009: from mtl_material_statuses
1010: WHERE status_id = p_onhand_status_id;
1011: --end of bug 6952533
1012: IF(l_allow_mixed_status = 2)THEN
1013: SELECT outermost_lpn_id into l_outermost_lpn_id
1270: mdebug(' update executed in sql: Onhand');
1271:
1272: -- Added the serial status check for bug # 7113129
1273: SELECT serial_control into l_serial_status_control
1274: from mtl_material_statuses
1275: WHERE status_id = p_onhand_status_id;
1276:
1277: IF (l_serial_status_control = 1) THEN
1278: OPEN cur_onhserial;
1471: WHERE REASON_ID = p_sub_reason_id;
1472:
1473: SELECT status_code
1474: INTO l_status_code
1475: FROM MTL_MATERIAL_STATUSES_VL
1476: WHERE status_id = p_sub_status_id;
1477:
1478: IF (l_debug = 1) THEN
1479: mdebug('l_workflow_name: '||l_workflow_name);
1528: WHERE REASON_ID = p_loc_reason_id;
1529:
1530: SELECT status_code
1531: INTO l_status_code
1532: FROM MTL_MATERIAL_STATUSES_VL
1533: WHERE status_id = p_loc_status_id;
1534:
1535: if l_workflow_name is not null THEN
1536:
1579: WHERE REASON_ID = p_lot_reason_id;
1580:
1581: SELECT status_code
1582: INTO l_status_code
1583: FROM MTL_MATERIAL_STATUSES_VL
1584: WHERE status_id = p_lot_status_id;
1585:
1586: if l_workflow_name is not null then
1587: wms_workflow_wrappers.wf_start_workflow
1632: WHERE REASON_ID = p_serial_reason_id;
1633:
1634: SELECT status_code
1635: INTO l_status_code
1636: FROM MTL_MATERIAL_STATUSES_VL
1637: WHERE status_id = p_serial_status_id;
1638:
1639: if l_workflow_name is not null then
1640: wms_workflow_wrappers.wf_start_workflow
1689: WHERE REASON_ID = p_onhand_reason_id;
1690:
1691: SELECT status_code
1692: INTO l_status_code
1693: FROM MTL_MATERIAL_STATUSES_VL
1694: WHERE status_id = p_onhand_status_id;
1695:
1696: IF (l_debug = 1) THEN
1697: mdebug('l_workflow_name: '||l_workflow_name);