DBA Data[Home] [Help]

APPS.AHL_OSP_PO_REQ_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1255: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV

1251: p_osp_order_id IN NUMBER) IS
1252:
1253: CURSOR l_validate_item_csr(p_item_id IN NUMBER,
1254: p_org_id IN NUMBER) IS
1255: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV
1256: WHERE INVENTORY_ITEM_ID = p_item_id
1257: AND ENABLED_FLAG = G_YES_FLAG
1258: AND PURCHASING_ENABLED_FLAG = G_YES_FLAG
1259: AND INVENTORY_ITEM_FLAG = G_NO_FLAG -- No Physical Items