eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_FLOW_VALIDATION dependencies on MTL_SYSTEM_ITEMS

Line 29: from mtl_system_items msi

25: from mtl_transactions_interface mti
26: where rowid = p_rowid
27: and exists (
28: select 1
29: from mtl_system_items msi
30: where msi.inventory_item_id = mti.inventory_item_id
31: and msi.organization_id = mti.organization_id
32: and msi.build_in_wip_flag = 'Y'
33: and msi.pick_components_flag = 'N'

Line 152: mtl_system_items msi

148: **********************************************/
149:
150: /* select 1 into x_success
151: from mtl_transactions_interface mti,
152: mtl_system_items msi
153: where mti.rowid = p_rowid
154: and msi.inventory_item_id = mti.inventory_item_id
155: and msi.organization_id = mti.organization_id
156: and ( (

Line 180: mtl_system_items msi

176: if (x_bom_rev_exists in (1, 0) ) then
177:
178: select 1 into x_success
179: from mtl_transactions_interface mti,
180: mtl_system_items msi
181: where mti.rowid = p_rowid
182: and msi.inventory_item_id = mti.inventory_item_id
183: and msi.organization_id = mti.organization_id
184: and ( (

Line 269: mtl_system_items msi

265: if ( x_rtg_exists >=0 ) then
266:
267: select 1 into x_success
268: from mtl_transactions_interface mti,
269: mtl_system_items msi
270: where mti.rowid = p_rowid
271: and msi.inventory_item_id = mti.inventory_item_id
272: and msi.organization_id = mti.organization_id
273: and ( (x_rtg_exists >= 1

Line 563: from mtl_system_items msi

559: and subinventory_code is not null
560: and exists (
561: (
562: select 1
563: from mtl_system_items msi
564: where mti.inventory_item_id = msi.inventory_item_id
565: and mti.organization_id = msi.organization_id
566: and msi.restrict_subinventories_code = 2
567: )

Line 570: from mtl_system_items msi, mtl_item_sub_val_v msvv

566: and msi.restrict_subinventories_code = 2
567: )
568: union (
569: select 1
570: from mtl_system_items msi, mtl_item_sub_val_v msvv
571: where mti.inventory_item_id = msi.inventory_item_id
572: and mti.organization_id = msi.organization_id
573: and msi.restrict_subinventories_code = 1
574: and msi.inventory_asset_flag = 'N'

Line 582: from mtl_system_items msi, mtl_item_sub_ast_trk_val_v msvv

578: mti.subinventory_code
579: )
580: union (
581: select 1
582: from mtl_system_items msi, mtl_item_sub_ast_trk_val_v msvv
583: where mti.inventory_item_id = msi.inventory_item_id
584: and mti.organization_id = msi.organization_id
585: and msi.restrict_subinventories_code = 1
586: and msi.inventory_asset_flag = 'Y'