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_TEMP_TABLE

Line 719: l_temp_itemids_query CONSTANT VARCHAR2(200) := ' IN (select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)';

715: l_api_name CONSTANT VARCHAR2(30) := 'Get_Related_Items';
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

Line 730: ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)

726: l_wout_mtl_mult_stmt CONSTANT VARCHAR2(2000) :=
727: ' SELECT DISTINCT ICRI.related_item_id FROM ibe_ct_related_items ICRI, mtl_system_items_b MSIB
728: WHERE ICRI.relation_type_code = :rel_type_code1
729: AND ICRI.inventory_item_id IN
730: ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)
731: AND NOT EXISTS( SELECT NULL
732: FROM ibe_ct_rel_exclusions ICRE
733: WHERE ICRE.relation_type_code = ICRI.relation_type_code
734: AND ICRE.inventory_item_id = ICRI.inventory_item_id

Line 749: IN ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)

745: 'SELECT DISTINCT ICRI.related_item_id FROM ibe_ct_related_items ICRI,
746: mtl_system_items_b MSIB
747: WHERE ICRI.relation_type_code = :rel_type_code1
748: AND ICRI.inventory_item_id
749: IN ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)
750: AND MSIB.organization_id = :org_id3
751: AND MSIB.organization_id = ICRI.organization_id --Bug 2922902
752: AND MSIB.inventory_item_id = ICRI.related_item_id
753: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE

Line 768: IN ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)

764: 3, ''UP_SELL'', 4, ''SERVICE'', 5, ''PREREQUISITE'', 6, ''COLLATERAL'',
765: 7, ''SUPERSEDED'', 8, ''COMPLIMENTARY'', 9, ''IMPACT'', 10, ''CONFLICT'',
766: ''MANDATORY_CHARGE'', 12, ''OPTIONAL_CHARGE'', 13, ''PROMOTIONAL_UPGRADE'' ,14)
767: AND MRI.inventory_item_id
768: IN ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)
769: AND MSIB.organization_id = :org_id7
770: AND MSIB.organization_id = MRI.organization_id --Bug 2922902
771: AND MSIB.inventory_item_id = MRI.related_item_id
772: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE

Line 787: AND MRI.related_item_id IN ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)

783: WHERE MRI.relationship_type_id = DECODE(:rel_type_code9, ''RELATED'', 1, ''SUBSTITUTE'', 2, ''CROSS_SELL'',
784: 3, ''UP_SELL'', 4, ''SERVICE'', 5, ''PREREQUISITE'', 6, ''COLLATERAL'',
785: 7, ''SUPERSEDED'', 8, ''COMPLIMENTARY'', 9, ''IMPACT'', 10, ''CONFLICT'',
786: 11, ''MANDATORY_CHARGE'', 12, ''OPTIONAL_CHARGE'', 13, ''PROMOTIONAL_UPGRADE'' ,14)
787: AND MRI.related_item_id IN ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)
788: AND MSIB.organization_id = :org_id11
789: AND MSIB.organization_id = MRI.organization_id --Bug 2922902
790: AND MSIB.inventory_item_id = MRI.inventory_item_id
791: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE

Line 802: IN ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)

798: SELECT ICRE.related_item_id
799: FROM ibe_ct_rel_exclusions ICRE
800: WHERE ICRE.relation_type_code = :rel_type_code13
801: AND ICRE.inventory_item_id
802: IN ( select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)
803: AND ICRE.organization_id = :org_id15 '; --Bug 2922902
804: l_wout_mtl_bulk_mult_stmt CONSTANT VARCHAR2(2000) :=
805: ' BEGIN
806: SELECT DISTINCT ICRI.related_item_id

Line 812: select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key )

808: FROM ibe_ct_related_items ICRI,
809: mtl_system_items_b MSIB
810: WHERE ICRI.relation_type_code = :rel_type_code2
811: AND ICRI.inventory_item_id IN (
812: select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key )
813: AND NOT EXISTS( SELECT NULL
814: FROM ibe_ct_rel_exclusions ICRE
815: WHERE ICRE.relation_type_code = ICRI.relation_type_code
816: AND ICRE.inventory_item_id = ICRI.inventory_item_id

Line 832: select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)

828: FROM ibe_ct_related_items ICRI,
829: mtl_system_items_b MSIB
830: WHERE ICRI.relation_type_code = :rel_type_code1
831: AND ICRI.inventory_item_id IN (
832: select NUM_VAL from IBE_TEMP_TABLE where key = :l_temp_key)
833: AND NOT EXISTS( SELECT NULL
834: FROM ibe_ct_rel_exclusions ICRE
835: WHERE ICRE.relation_type_code = ICRI.relation_type_code
836: AND ICRE.inventory_item_id = ICRI.inventory_item_id

Line 1169: IBE_UTIL.debug('Inserting to ibe_temp_table.');

1165: END IF;
1166:
1167: -- Populate the itemIds into a temporary table.
1168: IF (l_debug = 'Y') THEN
1169: IBE_UTIL.debug('Inserting to ibe_temp_table.');
1170: END IF;
1171:
1172: FOR i in p_item_ids.FIRST .. p_item_ids.LAST
1173: LOOP

Line 1447: SELECT COUNT(*) INTO l_dummy from ibe_temp_table;

1443: p_rel_type_code, p_item_ids(1), p_org_id, p_item_ids(1) ,
1444: p_rel_type_code, p_item_ids(1), p_org_id; --Bug 2922902
1445: END IF;
1446: ELSE -- Cust UI Mode
1447: SELECT COUNT(*) INTO l_dummy from ibe_temp_table;
1448: IF (l_debug = 'Y') THEN
1449: IBE_UTIL.debug('B4 QUERY '||l_dummy||'type code '||p_rel_type_code ||'key '||l_temp_key||'org id '||p_org_id||'msite id' ||p_msite_id);
1450: END IF;
1451: