DBA Data[Home] [Help]

APPS.WIP_EAMMTLPROC_PRIV dependencies on MTL_PARAMETERS

Line 130: from mtl_system_items msi, mtl_parameters mp

126: and process_flag = 1
127: and transaction_source_type_id = 5
128: and rebuild_item_id is not null
129: and not exists(select 1
130: from mtl_system_items msi, mtl_parameters mp
131: where mti.rebuild_item_id = msi.inventory_item_id
132: and msi.organization_id = mp.organization_id
133: and mp.maint_organization_id = mti.organization_id
134: and msi.eam_item_type = 3

Line 301: from mtl_system_items msi, mtl_parameters mp

297: and transaction_source_type_id = 5
298: and rebuild_item_id is not null
299: and rebuild_serial_number is not null
300: and not exists(select 1
301: from mtl_system_items msi, mtl_parameters mp
302: where mti.rebuild_item_id = msi.inventory_item_id
303: and mti.organization_id = mp.maint_organization_id
304: and mp.organization_id = msi.organization_id
305: and msi.serial_number_control_code in (wip_constants.full_sn,