APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on MTL_PARAMETERS

Line 2309: mtl_parameters param

2305: SELECT p_key,
2306: p_index_tbl(i),
2307: TO_NUMBER(org_info.org_information3)
2308: FROM hr_organization_information org_info,
2309: mtl_parameters param
2310: WHERE param.organization_id = p_ship_to_org_id_tbl(i)
2311: AND param.organization_id = org_info.organization_id
2312: AND org_info.org_information_context = 'Accounting Information';
2313:

Line 2999: mtl_parameters param

2995: p_index_tbl(i),
2996: sob.chart_of_accounts_id
2997: FROM gl_sets_of_books sob,
2998: hr_organization_information org_info,
2999: mtl_parameters param
3000: WHERE p_txn_flow_header_id_tbl(i) IS NOT NULL
3001: AND p_dest_charge_account_id_tbl(i) IS NULL
3002: AND param.organization_id = p_dest_org_id_tbl(i)
3003: AND param.organization_id = org_info.organization_id

Line 4246: FROM mtl_parameters

4242: d_position := 60;
4243: SELECT ap_accrual_account, invoice_price_var_account
4244: INTO g_mtl_accrual_account_id_tbl(p_dest_org_id),
4245: g_mtl_variance_account_id_tbl(p_dest_org_id)
4246: FROM mtl_parameters
4247: WHERE organization_id = p_dest_org_id;
4248: END IF;
4249:
4250: IF (x_accrual_account_id IS NULL) THEN

Line 4268: -- inventories, then mtl_system_items and finally mtl_parameters

4264:
4265: d_position := 70;
4266:
4267: -- first try to get it from mtl_item_sub_inventories, then mtl_secondary_
4268: -- inventories, then mtl_system_items and finally mtl_parameters
4269: -- Bug6811980 (including the exception block)
4270: BEGIN
4271: SELECT NVL(misi.encumbrance_account, msci.encumbrance_account)
4272: INTO x_budget_account_id

Line 4294: mtl_parameters mp

4290:
4291: SELECT NVL(msi.encumbrance_account, mp.encumbrance_account)
4292: INTO x_budget_account_id
4293: FROM mtl_system_items msi,
4294: mtl_parameters mp
4295: WHERE p_item_id = msi.inventory_item_id
4296: AND p_dest_org_id = msi.organization_id
4297: AND mp.organization_id = p_dest_org_id;
4298: END IF;