DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on MTL_PARAMETERS

Line 336: FROM mtl_parameters

332:
333: --Start 2878098 WIP Locator mandatory by loc contrl
334: CURSOR c_org_loc_control(cp_org_id number) IS
335: SELECT stock_locator_control_code,negative_inv_receipt_code
336: FROM mtl_parameters
337: where organization_id = cp_org_id;
338:
339: CURSOR c_subinv_loc_control(cp_org_id number,
340: cp_subinv_name varchar2) IS

Line 932: from MTL_PARAMETERS

928: from MTL_SYSTEM_ITEMS msi
929: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
930: and ORGANIZATION_ID in
931: ( select MASTER_ORGANIZATION_ID
932: from MTL_PARAMETERS
933: where ORGANIZATION_ID = MASTER_ORGANIZATION_ID )
934: and rownum = 1
935: and not exists
936: (select UNIT_OF_MEASURE