APPS.AHL_OSP_PO_PVT dependencies on MTL_PARAMETERS

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: */

Line 3298: FROM mtl_parameters

3294: AND inventory_item_id = c_item_id;
3295:
3296: CURSOR get_mtl_acct_org_csr(c_inv_org_id IN NUMBER) IS
3297: SELECT material_account
3298: FROM mtl_parameters
3299: WHERE organization_id = c_inv_org_id;
3300:
3301: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.get_charge_account_id';
3302: l_charge_acct_id NUMBER := null;