DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on MTL_MATERIAL_STATUSES_VL

Line 734: FROM mtl_material_statuses_vl

730: IF p_status_id IS NOT NULL THEN
731: BEGIN
732: SELECT status_id
733: INTO l_status_id
734: FROM mtl_material_statuses_vl
735: WHERE status_id = p_status_id
736: AND enabled_flag = 1;
737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN

Line 1637: FROM mtl_material_statuses_vl

1633: AND p_status_id IS NOT NULL) THEN
1634: BEGIN
1635: SELECT 1
1636: INTO l_chkflg
1637: FROM mtl_material_statuses_vl
1638: WHERE status_id = p_status_id
1639: AND enabled_flag = 1;
1640: EXCEPTION
1641: WHEN NO_DATA_FOUND THEN

Line 2110: FROM mtl_material_statuses_vl

2106: IF p_status_id IS NOT NULL THEN
2107: BEGIN
2108: SELECT 1
2109: INTO l_status_chk
2110: FROM mtl_material_statuses_vl
2111: WHERE status_id = p_status_id
2112: AND enabled_flag = 1;
2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN