APPS.INV_STATUS_PKG dependencies on MTL_MATERIAL_STATUSES_VL

Line 218: FROM MTL_MATERIAL_STATUSES_VL

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;

Line 300: FROM MTL_MATERIAL_STATUSES_VL

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;

Line 1475: FROM MTL_MATERIAL_STATUSES_VL

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

Line 1532: FROM MTL_MATERIAL_STATUSES_VL

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:

Line 1583: FROM MTL_MATERIAL_STATUSES_VL

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

Line 1636: FROM MTL_MATERIAL_STATUSES_VL

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

Line 1693: FROM MTL_MATERIAL_STATUSES_VL

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