APPS.PO_SHARED_PROC_PVT dependencies on MTL_PARAMETERS

Line 258: mtl_parameters mp

254: SELECT gsb.chart_of_accounts_id
255: INTO l_coa_id
256: FROM gl_sets_of_books gsb,
257: hr_organization_information hoi,
258: mtl_parameters mp
259: WHERE mp.organization_id = p_inv_org_id
260: AND mp.organization_id = hoi.organization_id
261: AND hoi.org_information_context = 'Accounting Information'
262: AND TO_NUMBER(hoi.org_information1) = gsb.set_of_books_id;

Line 325: mtl_parameters mp

321: SELECT TO_NUMBER(hoi.org_information3), gsb.chart_of_accounts_id
322: INTO x_ou_id, x_coa_id
323: FROM gl_sets_of_books gsb,
324: hr_organization_information hoi,
325: mtl_parameters mp
326: WHERE mp.organization_id = p_inv_org_id
327: AND mp.organization_id = hoi.organization_id
328: AND hoi.org_information_context = 'Accounting Information'
329: AND TO_NUMBER(hoi.org_information1) = gsb.set_of_books_id;

Line 1157: mtl_parameters mp

1153: l_progress := '020';
1154: SELECT 'Y'
1155: INTO l_valid_flag
1156: FROM mtl_system_items_b msi,
1157: mtl_parameters mp
1158: WHERE msi.inventory_item_id = p_item_id
1159: AND msi.organization_id = p_inv_org_id
1160: AND mp.organization_id = msi.organization_id;
1161: ELSE

Line 1170: mtl_parameters mp

1166: SELECT 'Y'
1167: INTO l_valid_flag
1168: FROM mtl_system_items_b msi,
1169: mtl_item_revisions_b mir,
1170: mtl_parameters mp
1171: WHERE msi.inventory_item_id = p_item_id
1172: AND msi.organization_id = p_inv_org_id
1173: AND mir.organization_id = msi.organization_id
1174: AND mir.inventory_item_id = msi.inventory_item_id

Line 1289: l_ship_to_org_opm_flag MTL_PARAMETERS.process_enabled_flag%TYPE;

1285: l_current_r_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
1286:
1287: l_end_ou_id NUMBER; -- query converts to number
1288: l_ship_to_org_sob_id NUMBER; -- query converts to number
1289: l_ship_to_org_opm_flag MTL_PARAMETERS.process_enabled_flag%TYPE;
1290:
1291: l_return_status VARCHAR2(1);
1292: l_progress VARCHAR2(3);
1293:

Line 1341: --mtl_parameters mp

1337: INTO l_end_ou_id,
1338: l_ship_to_org_sob_id
1339: --l_ship_to_org_opm_flag
1340: FROM hr_organization_information hoi
1341: --mtl_parameters mp
1342: WHERE
1343: -- MC INVCONV START
1344: hoi.organization_id = p_ship_to_org_id
1345: --mp.organization_id = p_ship_to_org_id