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 181: mtl_system_items msi

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

Line 270: mtl_system_items msi

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

Line 562: from mtl_system_items msi

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

Line 569: from mtl_system_items msi, mtl_item_sub_val_v msvv

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

Line 581: from mtl_system_items msi, mtl_item_sub_ast_trk_val_v msvv

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