APPS.IBC_LOAD_CITEMS_PVT dependencies on IBC_CITEM_VERSION_LABELS

Line 23: FROM ibc_citem_version_labels

19: x_label_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
20: ) AS
21: CURSOR Get_Citems IS
22: SELECT content_item_id, citem_version_id, label_code
23: FROM ibc_citem_version_labels
24: WHERE content_item_id IN (select distinct a.CONTENT_ITEM_ID
25: from ibc_associations a, ibc_content_items c
26: where a.content_item_id = c.content_item_id
27: and c.content_item_status = 'APPROVED'

Line 31: FROM ibc_citem_version_labels

27: and c.content_item_status = 'APPROVED'
28: and c.WD_RESTRICTED_FLAG = 'F'
29: and c.LIVE_CITEM_VERSION_ID IS NOT NULL)
30: AND ROWID IN (SELECT MAX(ROWID)
31: FROM ibc_citem_version_labels
32: GROUP BY content_item_id, citem_version_id)
33: UNION
34: SELECT a.*
35: FROM (select distinct a.CONTENT_ITEM_ID, c.live_citem_version_id as citem_version_id,

Line 43: FROM ibc_citem_version_labels b

39: and c.content_item_status = 'APPROVED'
40: and c.WD_RESTRICTED_FLAG = 'F'
41: and c.LIVE_CITEM_VERSION_ID IS NOT NULL) a
42: WHERE NOT EXISTS (SELECT NULL
43: FROM ibc_citem_version_labels b
44: WHERE b.citem_version_id = a.citem_version_id);
45:
46: BEGIN
47: OPEN Get_Citems;