APPS.AHL_OSP_PO_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1519: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV

1515: p_osp_order_id IN NUMBER) IS
1516:
1517: CURSOR l_validate_item_csr(p_item_id IN NUMBER,
1518: p_org_id IN NUMBER) IS
1519: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV
1520: WHERE INVENTORY_ITEM_ID = p_item_id
1521: AND ENABLED_FLAG = G_YES_FLAG
1522: AND PURCHASING_ENABLED_FLAG = G_YES_FLAG
1523: AND INVENTORY_ITEM_FLAG = G_NO_FLAG -- No Physical Items

Line 1845: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV

1841: -- Calling the new utility method Get_Item_Price instead
1842: /*
1843: CURSOR l_chk_price_csr(p_item_id IN NUMBER,
1844: p_org_id IN NUMBER) IS
1845: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV
1846: WHERE INVENTORY_ITEM_ID = p_item_id
1847: AND ORGANIZATION_ID = p_org_id
1848: AND LIST_PRICE_PER_UNIT IS NOT NULL;
1849: */

Line 3263: SELECT MSIK.LIST_PRICE_PER_UNIT FROM MTL_SYSTEM_ITEMS_KFV MSIK, MTL_PARAMETERS MP

3259: AND MSIB.ORGANIZATION_ID = ospl.inventory_org_id
3260: AND ospl.osp_order_line_id = p_osp_line_id;
3261: /*
3262: CURSOR l_get_master_price_csr IS
3263: SELECT MSIK.LIST_PRICE_PER_UNIT FROM MTL_SYSTEM_ITEMS_KFV MSIK, MTL_PARAMETERS MP
3264: WHERE MSIK.INVENTORY_ITEM_ID = p_item_id
3265: AND MSIK.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
3266: AND MP.ORGANIZATION_ID = p_org_id;
3267: */