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 1170: DELETE IBE_CT_RELATED_ITEMS

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

Line 1176: DELETE IBE_CT_RELATED_ITEMS

1172: AND relation_rule_id = l_rel_rule_id
1173: AND inventory_item_id = p_inventory_item_id
1174: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591
1175: ELSE
1176: DELETE IBE_CT_RELATED_ITEMS
1177: WHERE relation_type_code = l_relation_type_code
1178: AND relation_rule_id = l_rel_rule_id
1179: AND inventory_item_id = p_inventory_item_id
1180: AND organization_id = p_organization_id; --Bug 2922902

Line 1203: DELETE IBE_CT_RELATED_ITEMS

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

Line 1209: DELETE IBE_CT_RELATED_ITEMS

1205: AND relation_rule_id = l_rel_rule_id
1206: AND related_item_id = p_inventory_item_id
1207: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591
1208: ELSE
1209: DELETE IBE_CT_RELATED_ITEMS
1210: WHERE relation_type_code = l_relation_type_code
1211: AND relation_rule_id = l_rel_rule_id
1212: AND related_item_id = p_inventory_item_id
1213: AND organization_id = p_organization_id; --Bug 2922902

Line 1251: DELETE IBE_CT_RELATED_ITEMS

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

Line 1257: DELETE IBE_CT_RELATED_ITEMS

1253: AND relation_rule_id = l_rel_rule_id
1254: AND inventory_item_id = p_inventory_item_id
1255: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591
1256: ELSE
1257: DELETE IBE_CT_RELATED_ITEMS
1258: WHERE relation_type_code = l_relation_type_code
1259: AND relation_rule_id = l_rel_rule_id
1260: AND inventory_item_id = p_inventory_item_id
1261: AND organization_id = p_organization_id; --Bug 2922902

Line 1283: DELETE IBE_CT_RELATED_ITEMS

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

Line 1289: DELETE IBE_CT_RELATED_ITEMS

1285: AND relation_rule_id = l_rel_rule_id
1286: AND related_item_id = p_inventory_item_id
1287: AND organization_id = L_ORGANIZATION_ID; --Bug 3001591
1288: ELSE
1289: DELETE IBE_CT_RELATED_ITEMS
1290: WHERE relation_type_code = l_relation_type_code
1291: AND relation_rule_id = l_rel_rule_id
1292: AND related_item_id = p_inventory_item_id
1293: AND organization_id = p_organization_id; --Bug 2922902

Line 1368: FROM IBE_CT_RELATED_ITEMS

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

Line 1375: FROM IBE_CT_RELATED_ITEMS

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