eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_PROD_RELATION_GRP dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 70: SELECT COUNT(B.SECTION_ITEM_ID) INTO rowsReturned FROM IBE_DSP_SECTION_ITEMS s, IBE_DSP_MSITE_SCT_ITEMS b

66: FUNCTION isBelongToMinisite(p_item_id IN NUMBER, p_msite_id IN NUMBER) RETURN BOOLEAN
67: IS
68: rowsReturned NUMBER :=0;
69: BEGIN
70: SELECT COUNT(B.SECTION_ITEM_ID) INTO rowsReturned FROM IBE_DSP_SECTION_ITEMS s, IBE_DSP_MSITE_SCT_ITEMS b
71: WHERE S.SECTION_ITEM_ID = B.SECTION_ITEM_ID AND B.MINI_SITE_ID = p_msite_id
72: AND S.INVENTORY_ITEM_ID = p_item_id
73: AND NVL(S.START_DATE_ACTIVE,SYSDATE) <= SYSDATE
74: AND NVL(S.END_DATE_ACTIVE,SYSDATE) >= SYSDATE;

Line 720: l_minisite_stmt CONSTANT VARCHAR2(2000) :=' AND EXISTS (SELECT 1 FROM IBE_DSP_SECTION_ITEMS s, IBE_DSP_MSITE_SCT_ITEMS b

716: l_api_version CONSTANT NUMBER := 1.0;
717: l_status VARCHAR2(5);
718: l_temp VARCHAR(20000);
719: l_temp_itemids_query CONSTANT VARCHAR2(200) := ' IN (select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)';
720: l_minisite_stmt CONSTANT VARCHAR2(2000) :=' AND EXISTS (SELECT 1 FROM IBE_DSP_SECTION_ITEMS s, IBE_DSP_MSITE_SCT_ITEMS b
721: WHERE S.SECTION_ITEM_ID = B.SECTION_ITEM_ID
722: AND B.MINI_SITE_ID = :msite_id
723: AND S.INVENTORY_ITEM_ID = ICRI.related_item_id
724: AND NVL(S.START_DATE_ACTIVE,SYSDATE) <= SYSDATE