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 IBE_CT_RELATED_ITEMS

Line 539: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATED_ITEMS.');

535: FROM ibe_ct_relation_rules
536: WHERE relation_type_code = p_rel_type_code_tbl(i);
537:
538: IF (l_debug = 'Y') THEN
539: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATED_ITEMS.');
540: END IF;
541: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
542: DELETE
543: FROM ibe_ct_related_items

Line 543: FROM ibe_ct_related_items

539: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATED_ITEMS.');
540: END IF;
541: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
542: DELETE
543: FROM ibe_ct_related_items
544: WHERE relation_type_code = p_rel_type_code_tbl(i);
545:
546: IF (l_debug = 'Y') THEN
547: IBE_UTIL.debug('Deleting rows in IBE_CT_REL_EXCLUSIONS.');

Line 840: INSERT INTO IBE_CT_RELATED_ITEMS(

836:
837: IF p_origin_object_type = 'N' AND p_dest_object_type = 'N' THEN
838: NULL;
839: ELSIF p_origin_object_type = 'S' AND p_dest_object_type = 'S' THEN
840: INSERT INTO IBE_CT_RELATED_ITEMS(
841: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
842: related_item_id, object_version_number, created_by, creation_date,
843: last_updated_by, last_update_date
844: )

Line 855: INSERT INTO IBE_CT_RELATED_ITEMS(

851: AND JDSI2.section_id = p_dest_object_id
852: AND JDSI1.organization_id = JDSI2.organization_id; --Bug 2922902
853:
854: ELSIF p_origin_object_type = 'S' AND p_dest_object_type = 'C' THEN
855: INSERT INTO IBE_CT_RELATED_ITEMS(
856: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
857: related_item_id, object_version_number, created_by, creation_date,
858: last_updated_by, last_update_date
859: )

Line 871: INSERT INTO IBE_CT_RELATED_ITEMS(

867: AND MIC.category_id = p_dest_object_id
868: AND MIC.category_set_id = l_category_set_id_str; --Bug 2630696
869:
870: ELSIF p_origin_object_type = 'S' AND p_dest_object_type = 'I' THEN
871: INSERT INTO IBE_CT_RELATED_ITEMS(
872: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
873: related_item_id, object_version_number, created_by, creation_date,
874: last_updated_by, last_update_date
875: )

Line 884: INSERT INTO IBE_CT_RELATED_ITEMS(

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
884: INSERT INTO IBE_CT_RELATED_ITEMS(
885: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
886: related_item_id, object_version_number, created_by, creation_date,
887: last_updated_by, last_update_date
888: )

Line 900: INSERT INTO IBE_CT_RELATED_ITEMS(

896: AND JDSI.section_id = p_dest_object_id
897: AND MIC.category_set_id = l_category_set_id_str; --Bug 2630696
898:
899: ELSIF p_origin_object_type = 'C' AND p_dest_object_type = 'C' THEN
900: INSERT INTO IBE_CT_RELATED_ITEMS(
901: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
902: related_item_id, object_version_number, created_by, creation_date,
903: last_updated_by, last_update_date
904: )

Line 918: INSERT INTO IBE_CT_RELATED_ITEMS(

914: AND MIC1.category_set_id = MIC2.category_set_id --Bug 2630696
915: AND MIC1.category_set_id = l_category_set_id_str; --bug 2630696
916:
917: ELSIF p_origin_object_type = 'C' AND p_dest_object_type = 'I' THEN
918: INSERT INTO IBE_CT_RELATED_ITEMS(
919: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
920: related_item_id, object_version_number, created_by, creation_date,
921: last_updated_by, last_update_date
922: )

Line 932: INSERT INTO IBE_CT_RELATED_ITEMS(

928: AND MIC.category_id = p_origin_object_id
929: AND MIC.category_set_id = l_category_set_id_str; --Bug 2630696
930:
931: ELSIF p_origin_object_type = 'I' AND p_dest_object_type = 'S' THEN
932: INSERT INTO IBE_CT_RELATED_ITEMS(
933: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
934: related_item_id, object_version_number, created_by, creation_date,
935: last_updated_by, last_update_date
936: )

Line 945: INSERT INTO IBE_CT_RELATED_ITEMS(

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
945: INSERT INTO IBE_CT_RELATED_ITEMS(
946: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
947: related_item_id, object_version_number, created_by, creation_date,
948: last_updated_by, last_update_date
949: )

Line 959: INSERT INTO IBE_CT_RELATED_ITEMS(

955: AND MIC.category_id = p_dest_object_id
956: AND MIC.category_set_id = l_category_set_id_str; --Bug 2630696
957:
958: ELSIF p_origin_object_type = 'I' AND p_dest_object_type = 'I' THEN
959: INSERT INTO IBE_CT_RELATED_ITEMS(
960: organization_id, relation_type_code, relation_rule_id, inventory_item_id,
961: related_item_id, object_version_number, created_by, creation_date,
962: last_updated_by, last_update_date
963: )

Line 979: FROM IBE_CT_RELATED_ITEMS ICRI

975: BEGIN
976: DELETE
977: FROM IBE_CT_REL_EXCLUSIONS ICRE
978: WHERE NOT EXISTS( SELECT NULL
979: FROM IBE_CT_RELATED_ITEMS ICRI
980: WHERE ICRI.relation_type_code = ICRE.relation_type_code
981: AND ICRI.inventory_item_id = ICRE.inventory_item_id
982: AND ICRI.organization_id = ICRE.organization_id --Bug 2922902
983: AND ICRI.related_item_id = ICRE.related_item_id );

Line 1174: DELETE IBE_CT_RELATED_ITEMS

1170:
1171: -- Delete all the related items created by the rule
1172: -- affected by the given category and deleted item
1173: IF (p_organization_id IS NULL) THEN
1174: DELETE IBE_CT_RELATED_ITEMS
1175: WHERE relation_type_code = l_relation_type_code
1176: AND relation_rule_id = l_rel_rule_id
1177: AND inventory_item_id = p_inventory_item_id
1178: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591

Line 1180: DELETE IBE_CT_RELATED_ITEMS

1176: AND relation_rule_id = l_rel_rule_id
1177: AND inventory_item_id = p_inventory_item_id
1178: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591
1179: ELSE
1180: DELETE IBE_CT_RELATED_ITEMS
1181: WHERE relation_type_code = l_relation_type_code
1182: AND relation_rule_id = l_rel_rule_id
1183: AND inventory_item_id = p_inventory_item_id
1184: AND organization_id = p_organization_id; --Bug 2922902

Line 1207: DELETE IBE_CT_RELATED_ITEMS

1203:
1204: -- Delete all the related items created by the rule
1205: -- affected by the given category and deleted item
1206: IF (p_organization_id IS NULL) THEN
1207: DELETE IBE_CT_RELATED_ITEMS
1208: WHERE relation_type_code = l_relation_type_code
1209: AND relation_rule_id = l_rel_rule_id
1210: AND related_item_id = p_inventory_item_id
1211: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591

Line 1213: DELETE IBE_CT_RELATED_ITEMS

1209: AND relation_rule_id = l_rel_rule_id
1210: AND related_item_id = p_inventory_item_id
1211: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591
1212: ELSE
1213: DELETE IBE_CT_RELATED_ITEMS
1214: WHERE relation_type_code = l_relation_type_code
1215: AND relation_rule_id = l_rel_rule_id
1216: AND related_item_id = p_inventory_item_id
1217: AND organization_id = p_organization_id; --Bug 2922902

Line 1255: DELETE IBE_CT_RELATED_ITEMS

1251:
1252: -- Delete all the related items created by the rule
1253: -- affected by the given section and deleted item
1254: IF (p_organization_id IS NULL) THEN
1255: DELETE IBE_CT_RELATED_ITEMS
1256: WHERE relation_type_code = l_relation_type_code
1257: AND relation_rule_id = l_rel_rule_id
1258: AND inventory_item_id = p_inventory_item_id
1259: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591

Line 1261: DELETE IBE_CT_RELATED_ITEMS

1257: AND relation_rule_id = l_rel_rule_id
1258: AND inventory_item_id = p_inventory_item_id
1259: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591
1260: ELSE
1261: DELETE IBE_CT_RELATED_ITEMS
1262: WHERE relation_type_code = l_relation_type_code
1263: AND relation_rule_id = l_rel_rule_id
1264: AND inventory_item_id = p_inventory_item_id
1265: AND organization_id = p_organization_id; --Bug 2922902

Line 1287: DELETE IBE_CT_RELATED_ITEMS

1283:
1284: -- Delete all the related items created by the rule
1285: -- affected by the given category and deleted item
1286: IF (p_organization_id IS NULL) THEN
1287: DELETE IBE_CT_RELATED_ITEMS
1288: WHERE relation_type_code = l_relation_type_code
1289: AND relation_rule_id = l_rel_rule_id
1290: AND related_item_id = p_inventory_item_id
1291: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591

Line 1293: DELETE IBE_CT_RELATED_ITEMS

1289: AND relation_rule_id = l_rel_rule_id
1290: AND related_item_id = p_inventory_item_id
1291: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591
1292: ELSE
1293: DELETE IBE_CT_RELATED_ITEMS
1294: WHERE relation_type_code = l_relation_type_code
1295: AND relation_rule_id = l_rel_rule_id
1296: AND related_item_id = p_inventory_item_id
1297: AND organization_id = p_organization_id; --Bug 2922902

Line 1372: FROM IBE_CT_RELATED_ITEMS

1368:
1369: -- 3. Remove all the rows in Related Items table
1370: -- that have the deleted item as inventory item
1371: DELETE
1372: FROM IBE_CT_RELATED_ITEMS
1373: WHERE inventory_item_id = p_inventory_item_id
1374: AND organization_id = p_organization_id;
1375:
1376: -- 4. Remove all the rows in Related Items table

Line 1379: FROM IBE_CT_RELATED_ITEMS

1375:
1376: -- 4. Remove all the rows in Related Items table
1377: -- that have the deleted item as related item
1378: DELETE
1379: FROM IBE_CT_RELATED_ITEMS
1380: WHERE related_item_id = p_inventory_item_id
1381: AND organization_id = p_organization_id;
1382:
1383: Remove_Invalid_Exclusions();