APPS.AHL_OSP_PO_PVT dependencies on MTL_PARAMETERS

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

Line 3265: FROM mtl_parameters

3261: AND inventory_item_id = c_item_id;
3262:
3263: CURSOR get_mtl_acct_org_csr(c_inv_org_id IN NUMBER) IS
3264: SELECT material_account
3265: FROM mtl_parameters
3266: WHERE organization_id = c_inv_org_id;
3267:
3268: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.get_charge_account_id';
3269: l_charge_acct_id NUMBER := null;