DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on MTL_MATERIAL_STATUSES_VL

Line 792: FROM mtl_material_statuses_vl

788: IF p_status_id IS NOT NULL THEN
789: BEGIN
790: SELECT status_id
791: INTO l_status_id
792: FROM mtl_material_statuses_vl
793: WHERE status_id = p_status_id
794: AND enabled_flag = 1;
795: EXCEPTION
796: WHEN NO_DATA_FOUND THEN

Line 1720: FROM mtl_material_statuses_vl

1716: AND p_status_id IS NOT NULL) THEN
1717: BEGIN
1718: SELECT 1
1719: INTO l_chkflg
1720: FROM mtl_material_statuses_vl
1721: WHERE status_id = p_status_id
1722: AND enabled_flag = 1;
1723: EXCEPTION
1724: WHEN NO_DATA_FOUND THEN

Line 2206: FROM mtl_material_statuses_vl

2202: IF p_status_id IS NOT NULL THEN
2203: BEGIN
2204: SELECT 1
2205: INTO l_status_chk
2206: FROM mtl_material_statuses_vl
2207: WHERE status_id = p_status_id
2208: AND enabled_flag = 1;
2209: EXCEPTION
2210: WHEN NO_DATA_FOUND THEN