APPS.IBE_PROD_RELATION_PVT dependencies on IBE_DSP_SECTION_ITEMS

Line 848: FROM IBE_DSP_SECTION_ITEMS JDSI1,

844: )
845: SELECT JDSI1.organization_id, p_rel_type_code, p_rel_rule_id, JDSI1.inventory_item_id,
846: JDSI2.inventory_item_id, 1, L_USER_ID, SYSDATE,
847: L_USER_ID, SYSDATE
848: FROM IBE_DSP_SECTION_ITEMS JDSI1,
849: IBE_DSP_SECTION_ITEMS JDSI2
850: WHERE JDSI1.section_id = p_origin_object_id
851: AND JDSI2.section_id = p_dest_object_id
852: AND JDSI1.organization_id = JDSI2.organization_id; --Bug 2922902

Line 849: IBE_DSP_SECTION_ITEMS JDSI2

845: SELECT JDSI1.organization_id, p_rel_type_code, p_rel_rule_id, JDSI1.inventory_item_id,
846: JDSI2.inventory_item_id, 1, L_USER_ID, SYSDATE,
847: L_USER_ID, SYSDATE
848: FROM IBE_DSP_SECTION_ITEMS JDSI1,
849: IBE_DSP_SECTION_ITEMS JDSI2
850: WHERE JDSI1.section_id = p_origin_object_id
851: AND JDSI2.section_id = p_dest_object_id
852: AND JDSI1.organization_id = JDSI2.organization_id; --Bug 2922902
853:

Line 863: FROM IBE_DSP_SECTION_ITEMS JDSI,

859: )
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

Line 879: FROM IBE_DSP_SECTION_ITEMS JDSI

875: )
876: SELECT p_organization_id, p_rel_type_code, p_rel_rule_id, JDSI.inventory_item_id,
877: p_dest_object_id, 1, L_USER_ID, SYSDATE,
878: L_USER_ID, SYSDATE
879: FROM IBE_DSP_SECTION_ITEMS JDSI
880: WHERE JDSI.section_id = p_origin_object_id
881: AND JDSI.organization_id = p_organization_id; --Bug 2922902
882:
883: ELSIF p_origin_object_type = 'C' AND p_dest_object_type = 'S' THEN

Line 893: IBE_DSP_SECTION_ITEMS JDSI

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
897: AND MIC.category_set_id = l_category_set_id_str; --Bug 2630696

Line 940: FROM IBE_DSP_SECTION_ITEMS JDSI

936: )
937: SELECT p_organization_id, p_rel_type_code, p_rel_rule_id, p_origin_object_id,
938: JDSI.inventory_item_id, 1, L_USER_ID, SYSDATE,
939: L_USER_ID, SYSDATE
940: FROM IBE_DSP_SECTION_ITEMS JDSI
941: WHERE JDSI.section_id = p_dest_object_id
942: AND JDSI.organization_id = p_organization_id; --Bug 2922902
943:
944: ELSIF p_origin_object_type = 'I' AND p_dest_object_type = 'C' THEN