APPS.CSP_SUPERSESSIONS_PVT dependencies on MTL_RELATED_ITEMS

Line 28: from MTL_RELATED_ITEMS mri

24:
25: CURSOR get_replacing_item(c_master_org_id NUMBER, c_item_id NUMBER)
26: IS
27: select mri.related_item_id
28: from MTL_RELATED_ITEMS mri
29: where mri.ORGANIZATION_ID = nvl(c_master_org_id,mri.ORGANIZATION_ID)
30: and mri.RELATIONSHIP_TYPE_ID = 8
31: and mri.inventory_item_id = c_item_id;
32:

Line 87: from MTL_RELATED_ITEMS mri

83: IS
84: select mri.inventory_item_id ,
85: mri.related_item_id,
86: mri.reciprocal_flag
87: from MTL_RELATED_ITEMS mri
88: where mri.ORGANIZATION_ID = c_master_org_id
89: and mri.RELATIONSHIP_TYPE_ID = 8;
90:
91: /*CURSOR get_supply_chain(c_master_org_id number,c_inv_item_id number)

Line 116: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi

112:
113: CURSOR bilateral_relation_item(c_related_item_id number,c_master_org_id number,c_inventory_item_id number)
114: IS
115: select MRI.inventory_item_id
116: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi
117: where mri.ORGANIZATION_ID = c_master_org_id
118: and mri.RELATIONSHIP_TYPE_ID = 8
119: and mri.related_item_id = c_related_item_id
120: and mri.reciprocal_flag = 'Y'

Line 220: from MTL_RELATED_ITEMS mri

216:
217: CURSOR get_replacing_item(c_master_org_id NUMBER, c_item_id NUMBER)
218: IS
219: select mri.related_item_id
220: from MTL_RELATED_ITEMS mri
221: where mri.ORGANIZATION_ID = c_master_org_id
222: and mri.RELATIONSHIP_TYPE_ID = 8
223: and mri.inventory_item_id = c_item_id;
224:

Line 339: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi

335: END LOOP;
336: l_where_string := l_where_string || ')' ;
337: END IF;
338: l_sql_string := 'select MRI.inventory_item_id
339: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi
340: where mri.ORGANIZATION_ID =' || p_master_org_id ||
341: 'and mri.RELATIONSHIP_TYPE_ID = 8
342: and mri.related_item_id =' || l_inventory_item_id ||
343: 'and mri.reciprocal_flag =' || '''' || 'Y' || '''' ||

Line 630: from MTL_RELATED_ITEMS mri

626:
627: CURSOR get_replaced_items(c_master_org_id number)
628: IS
629: select mri.inventory_item_id
630: from MTL_RELATED_ITEMS mri
631: where mri.ORGANIZATION_ID = c_master_org_id
632: and mri.RELATIONSHIP_TYPE_ID = 8;
633:
634: CURSOR get_repairable_items(c_item_id NUMBER, c_master_org_id NUMBER)

Line 637: from MTL_RELATED_ITEMS mri

633:
634: CURSOR get_repairable_items(c_item_id NUMBER, c_master_org_id NUMBER)
635: IS
636: select mri.inventory_item_id
637: from MTL_RELATED_ITEMS mri
638: where mri.ORGANIZATION_ID = c_master_org_id
639: and mri.RELATIONSHIP_TYPE_ID = 18
640: and mri.inventory_item_id <> c_item_id
641: and mri.RELATED_ITEM_ID = c_item_id ;

Line 670: FROM MTL_RELATED_ITEMS mri

666:
667: CURSOR get_replacing_item(c_master_org_id NUMBER, c_item_id NUMBER)
668: IS
669: SELECT mri.related_item_id
670: FROM MTL_RELATED_ITEMS mri
671: WHERE mri.ORGANIZATION_ID = c_master_org_id
672: AND mri.RELATIONSHIP_TYPE_ID = 8
673: AND mri.inventory_item_id = c_item_id;
674:

Line 821: from mtl_related_items mri,mtl_parameters mp

817:
818:
819: CURSOR is_item_repairable_to_self IS
820: select decode(mri.inventory_item_id,p_item_id,'Y','N')
821: from mtl_related_items mri,mtl_parameters mp
822: where mp.organization_id = p_org_id
823: and mri.organization_id = mp.master_organization_id
824: and mri.inventory_item_id = p_item_id
825: and mri.RELATIONSHIP_TYPE_ID = 18;

Line 983: from MTL_RELATED_ITEMS mri,mtl_system_items_b msi

979: BUILD_NOT_IN_CONDITION(p_master_org_id,l_item_id, l_where_string);
980: END IF;
981: IF l_where_string IS NOT NULL THEN
982: l_sql_string := 'select mri.inventory_item_id
983: from MTL_RELATED_ITEMS mri,mtl_system_items_b msi
984: where mri.ORGANIZATION_ID = ' || p_org_id ||
985: 'and mri.RELATIONSHIP_TYPE_ID = 18
986: and mri.inventory_item_id <> ' || l_item_id ||
987: 'and mri.RELATED_ITEM_ID = ' || l_item_id ||

Line 995: from MTL_RELATED_ITEMS mri,mtl_system_items_b msi

991: MSI.MTL_TRANSACTIONS_ENABLED_FLAG =' || '''' || 'Y' || '''' ||
992: ' and msi.organization_id = mri.ORGANIZATION_ID' ;
993: ELSE
994: l_sql_string := 'select mri.inventory_item_id
995: from MTL_RELATED_ITEMS mri,mtl_system_items_b msi
996: where mri.ORGANIZATION_ID = ' || p_org_id ||
997: 'and mri.RELATIONSHIP_TYPE_ID = 18
998: and mri.inventory_item_id <> ' || l_item_id ||
999: 'and mri.RELATED_ITEM_ID = ' || l_item_id ||

Line 1148: FROM mtl_related_items mri, mtl_parameters mp, mtl_system_items_b msi

1144: IS
1145:
1146: CURSOR get_supersede_item(c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
1147: SELECT mri.related_item_id
1148: FROM mtl_related_items mri, mtl_parameters mp, mtl_system_items_b msi
1149: WHERE mp.organization_id = c_organization_id
1150: AND mri.organization_id = mp.master_organization_id
1151: AND mri.inventory_item_id = c_inventory_item_id
1152: AND mri.RELATIONSHIP_TYPE_ID = 8

Line 1239: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi

1235: END IF;
1236: END LOOP;
1237: l_not_in_string := l_not_in_string || ')' ;
1238: l_sql_string := 'select MRI.inventory_item_id
1239: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi
1240: where mri.ORGANIZATION_ID =' || l_master_org ||
1241: 'and mri.RELATIONSHIP_TYPE_ID = 8
1242: and mri.related_item_id =' || p_inventory_item_id ||
1243: 'and mri.reciprocal_flag =' || '''' || 'Y' || '''' ||

Line 1299: from MTL_RELATED_ITEMS mri

1295: IS
1296: CURSOR get_replaced_item(c_master_org_id NUMBER, c_item_id NUMBER)
1297: IS
1298: select mri.inventory_item_id
1299: from MTL_RELATED_ITEMS mri
1300: where mri.ORGANIZATION_ID = nvl(c_master_org_id,mri.ORGANIZATION_ID)
1301: and mri.RELATIONSHIP_TYPE_ID = 8
1302: and mri.related_item_id = c_item_id;
1303:

Line 1436: from MTL_RELATED_ITEMS mriv, mtl_parameters mp

1432: l_supersede_items supersede_item_table_type;
1433:
1434: CURSOR get_supersede_item(p_item_id number, p_org_id number) IS
1435: select RELATED_ITEM_ID
1436: from MTL_RELATED_ITEMS mriv, mtl_parameters mp
1437: where mp.organization_id = p_org_id
1438: and mriv.inventory_item_id = p_item_id
1439: and mriv. organization_id = mp.master_organization_id
1440: and mriv.RELATIONSHIP_TYPE_ID = 8;