DBA Data[Home] [Help]

APPS.IBC_CITEM_RUNTIME_PVT dependencies on IBC_COMPOUND_RELATIONS

Line 429: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c

425: and t.language = i.BASE_LANGUAGE;
426:
427: CURSOR Get_Compound_Item_Ref IS
428: select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG
429: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
430: where r.CITEM_VERSION_ID = l_citem_version_id
431: and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
432: order by r.SORT_ORDER;
433:

Line 1099: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c

1095:
1096: CURSOR Get_Compound_Item_Ref IS
1097: select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID, c.ENCRYPT_FLAG,
1098: nvl(SUBITEM_VERSION_ID, nvl(LIVE_CITEM_VERSION_ID, (select max(VERSION_NUMBER) from IBC_CITEM_VERSIONS_B where CONTENT_ITEM_ID = r.CONTENT_ITEM_ID))) child_version_id
1099: from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
1100: where r.CITEM_VERSION_ID =p_citem_version_id
1101: and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
1102: order by r.SORT_ORDER;
1103: