APPS.INVIDIT2 dependencies on MTL_SYSTEM_ITEMS_B

Line 143: update mtl_system_items_b

139: -- Sync item catalog group. item across all orgs should have only one
140: -- catalog group. checks to see if same item in some other org has a
141: -- different item catalog and if so, syncs up.
142:
143: update mtl_system_items_b
144: set
145: item_catalog_group_id = X_item_catalog_group_id
146: where
147: inventory_item_id = X_item_id

Line 150: ( select 1 from mtl_system_items_b

146: where
147: inventory_item_id = X_item_id
148: and organization_id <> X_org_id
149: and exists
150: ( select 1 from mtl_system_items_b
151: where inventory_item_id = X_item_id and
152: organization_id <> X_org_id and
153: nvl (item_catalog_group_id, -1) <>
154: nvl (X_item_catalog_group_id, -1)

Line 361: and exists (select 'x' from mtl_system_items_B i

357: sysdate,
358: l_user_id
359: from mtl_parameters p
360: where p.master_organization_id = X_master_org_id
361: and exists (select 'x' from mtl_system_items_B i
362: where i.inventory_item_id =
363: X_item_id
364: and p.organization_id = i.organization_id);
365: end if;

Line 884: FROM mtl_system_items_b i

880: OR d.functional_area_id = DECODE( X_internal_order_flag, 'Y', 11, 0 )
881: )
882: AND EXISTS
883: ( SELECT 'x'
884: FROM mtl_system_items_b i
885: WHERE
886: i.inventory_item_id = X_item_id
887: AND i.organization_id = p.organization_id
888: )

Line 1071: FROM mtl_system_items_b i

1067: WHERE
1068: p.master_organization_id = X_master_org_id
1069: AND EXISTS
1070: ( SELECT 'x'
1071: FROM mtl_system_items_b i
1072: WHERE
1073: i.inventory_item_id = X_item_id
1074: AND i.organization_id = p.organization_id
1075: )

Line 1220: FROM mtl_system_items_b i

1216: OR d.functional_area_id = DECODE( X_internal_order_flag, 'Y', 11, 0 )
1217: )
1218: AND EXISTS
1219: ( SELECT 'x'
1220: FROM mtl_system_items_b i
1221: WHERE
1222: i.inventory_item_id = X_item_id
1223: AND i.organization_id = p.organization_id
1224: )