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_PVT dependencies on MTL_ITEM_CATEGORIES

Line 864: MTL_ITEM_CATEGORIES MIC

860: SELECT DISTINCT MIC.organization_id, p_rel_type_code, p_rel_rule_id,
861: JDSI.inventory_item_id, MIC.inventory_item_id, 1,
862: L_USER_ID, SYSDATE, L_USER_ID, SYSDATE
863: FROM IBE_DSP_SECTION_ITEMS JDSI,
864: MTL_ITEM_CATEGORIES MIC
865: WHERE JDSI.section_id = p_origin_object_id
866: AND MIC.organization_id = JDSI.organization_id --Bug 2922902
867: AND MIC.category_id = p_dest_object_id
868: AND MIC.category_set_id = l_category_set_id_str; --Bug 2630696

Line 892: FROM MTL_ITEM_CATEGORIES MIC,

888: )
889: SELECT DISTINCT MIC.organization_id, p_rel_type_code, p_rel_rule_id, MIC.inventory_item_id,
890: JDSI.inventory_item_id, 1, L_USER_ID, SYSDATE,
891: L_USER_ID, SYSDATE
892: FROM MTL_ITEM_CATEGORIES MIC,
893: IBE_DSP_SECTION_ITEMS JDSI
894: WHERE MIC.organization_id = JDSI.organization_id --Bug 2922902
895: AND MIC.category_id = p_origin_object_id
896: AND JDSI.section_id = p_dest_object_id

Line 908: FROM MTL_ITEM_CATEGORIES MIC1,

904: )
905: SELECT DISTINCT MIC1.organization_id, p_rel_type_code, p_rel_rule_id, MIC1.inventory_item_id,
906: MIC2.inventory_item_id, 1, L_USER_ID, SYSDATE,
907: L_USER_ID, SYSDATE
908: FROM MTL_ITEM_CATEGORIES MIC1,
909: MTL_ITEM_CATEGORIES MIC2
910: WHERE MIC1.organization_id = MIC2.organization_id --Bug 2922902
911: AND MIC1.category_id = p_origin_object_id
912: AND MIC2.category_id = p_dest_object_id

Line 909: MTL_ITEM_CATEGORIES MIC2

905: SELECT DISTINCT MIC1.organization_id, p_rel_type_code, p_rel_rule_id, MIC1.inventory_item_id,
906: MIC2.inventory_item_id, 1, L_USER_ID, SYSDATE,
907: L_USER_ID, SYSDATE
908: FROM MTL_ITEM_CATEGORIES MIC1,
909: MTL_ITEM_CATEGORIES MIC2
910: WHERE MIC1.organization_id = MIC2.organization_id --Bug 2922902
911: AND MIC1.category_id = p_origin_object_id
912: AND MIC2.category_id = p_dest_object_id
913: AND MIC1.organization_id = MIC2.organization_id --Bug 2630696

Line 926: FROM MTL_ITEM_CATEGORIES MIC

922: )
923: SELECT DISTINCT p_organization_id, p_rel_type_code, p_rel_rule_id, MIC.inventory_item_id,
924: p_dest_object_id, 1, L_USER_ID, SYSDATE,
925: L_USER_ID, SYSDATE
926: FROM MTL_ITEM_CATEGORIES MIC
927: WHERE MIC.organization_id = p_organization_id
928: AND MIC.category_id = p_origin_object_id
929: AND MIC.category_set_id = l_category_set_id_str; --Bug 2630696
930:

Line 953: FROM MTL_ITEM_CATEGORIES MIC

949: )
950: SELECT DISTINCT p_organization_id, p_rel_type_code, p_rel_rule_id, p_origin_object_id,
951: MIC.inventory_item_id, 1, L_USER_ID, SYSDATE,
952: L_USER_ID, SYSDATE
953: FROM MTL_ITEM_CATEGORIES MIC
954: WHERE MIC.organization_id = p_organization_id
955: AND MIC.category_id = p_dest_object_id
956: AND MIC.category_set_id = l_category_set_id_str; --Bug 2630696
957: