APPS.AHL_OSP_PO_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1511: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV

1507: p_osp_order_id IN NUMBER) IS
1508:
1509: CURSOR l_validate_item_csr(p_item_id IN NUMBER,
1510: p_org_id IN NUMBER) IS
1511: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV
1512: WHERE INVENTORY_ITEM_ID = p_item_id
1513: AND ENABLED_FLAG = G_YES_FLAG
1514: AND PURCHASING_ENABLED_FLAG = G_YES_FLAG
1515: AND INVENTORY_ITEM_FLAG = G_NO_FLAG -- No Physical Items

Line 1831: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV

1827: -- Calling the new utility method Get_Item_Price instead
1828: /*
1829: CURSOR l_chk_price_csr(p_item_id IN NUMBER,
1830: p_org_id IN NUMBER) IS
1831: SELECT 'x' FROM MTL_SYSTEM_ITEMS_KFV
1832: WHERE INVENTORY_ITEM_ID = p_item_id
1833: AND ORGANIZATION_ID = p_org_id
1834: AND LIST_PRICE_PER_UNIT IS NOT NULL;
1835: */

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

3226: AND MSIB.ORGANIZATION_ID = ospl.inventory_org_id
3227: AND ospl.osp_order_line_id = p_osp_line_id;
3228: /*
3229: CURSOR l_get_master_price_csr IS
3230: SELECT MSIK.LIST_PRICE_PER_UNIT FROM MTL_SYSTEM_ITEMS_KFV MSIK, MTL_PARAMETERS MP
3231: WHERE MSIK.INVENTORY_ITEM_ID = p_item_id
3232: AND MSIK.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
3233: AND MP.ORGANIZATION_ID = p_org_id;
3234: */