APPS.CLN_SYNCITEM_PKG dependencies on CLN_ITEMMST_ITEMHEADER_V

Line 180: FROM CLN_ITEMMST_ITEMHEADER_V

176: p_from_items VARCHAR2,
177: p_to_items VARCHAR2)
178: IS
179: SELECT concatenated_segments
180: FROM CLN_ITEMMST_ITEMHEADER_V
181: WHERE ORGANIZATION_ID= p_inventory_org_id
182: AND ( p_category_set_id IS NULL OR
183: p_category_set_id IN
184: ( SELECT mcsvc.category_set_id

Line 187: mic.inventory_item_id = CLN_ITEMMST_ITEMHEADER_V.INVENTORY_ITEM_ID AND

183: p_category_set_id IN
184: ( SELECT mcsvc.category_set_id
185: FROM mtl_item_categories mic, mtl_category_set_valid_cats mcsvc
186: WHERE mcsvc.category_set_id = mic.category_set_id AND
187: mic.inventory_item_id = CLN_ITEMMST_ITEMHEADER_V.INVENTORY_ITEM_ID AND
188: mic.organization_id = p_inventory_org_id
189: )
190: )
191: AND ( p_category_id IS NULL OR

Line 196: mic.inventory_item_id = CLN_ITEMMST_ITEMHEADER_V.INVENTORY_ITEM_ID AND

192: p_category_id IN
193: ( SELECT mcsvc.category_id
194: FROM mtl_item_categories mic, mtl_category_set_valid_cats mcsvc
195: WHERE mcsvc.category_id = mic.category_id AND
196: mic.inventory_item_id = CLN_ITEMMST_ITEMHEADER_V.INVENTORY_ITEM_ID AND
197: mic.organization_id = p_inventory_org_id
198: )
199: )
200: AND ( p_catalog_category_id IS NULL OR

Line 204: WHERE micgk.item_catalog_group_id = CLN_ITEMMST_ITEMHEADER_V.item_catalog_group_id

200: AND ( p_catalog_category_id IS NULL OR
201: p_catalog_category_id IN
202: ( SELECT micgk.item_catalog_group_id
203: FROM mtl_item_catalog_groups_kfv micgk
204: WHERE micgk.item_catalog_group_id = CLN_ITEMMST_ITEMHEADER_V.item_catalog_group_id
205: )
206: )
207: AND ( p_item_status IS NULL OR
208: INVENTORY_ITEM_STATUS_CODE = p_item_status)