DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on MTL_PARAMETERS

Line 334: FROM mtl_parameters

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

Line 906: from MTL_PARAMETERS

902: from MTL_SYSTEM_ITEMS msi
903: where INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID
904: and ORGANIZATION_ID in
905: ( select MASTER_ORGANIZATION_ID
906: from MTL_PARAMETERS
907: where ORGANIZATION_ID = MASTER_ORGANIZATION_ID )
908: and rownum = 1
909: and not exists
910: (select UNIT_OF_MEASURE