APPS.INV_STATUS_PKG dependencies on MTL_MATERIAL_STATUSES_VL

Line 162: FROM MTL_MATERIAL_STATUSES_VL

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;

Line 244: FROM MTL_MATERIAL_STATUSES_VL

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;

Line 853: FROM MTL_MATERIAL_STATUSES_VL

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);

Line 910: FROM MTL_MATERIAL_STATUSES_VL

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:

Line 961: FROM MTL_MATERIAL_STATUSES_VL

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

Line 1014: FROM MTL_MATERIAL_STATUSES_VL

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

Line 1071: FROM MTL_MATERIAL_STATUSES_VL

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);