APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSI_II_RELATIONSHIPS

Line 22: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_II_RELATIONSHIPS';

18: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';
21:
22: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_II_RELATIONSHIPS';
23: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC';
24: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_II_RELATIONSHIPS_ACC_S';
25: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
26: CSM_ACC_PKG.t_publication_item_list('CSF_M_II_RELATIONSHIPS');

Line 119: FROM CSI_II_RELATIONSHIPS CIR

115:
116: CURSOR c_parent_instance(c_instance_id NUMBER)
117: IS
118: SELECT CIR.OBJECT_ID
119: FROM CSI_II_RELATIONSHIPS CIR
120: WHERE CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
121: AND CIR.SUBJECT_ID = c_instance_id;
122:
123: BEGIN

Line 381: , CSI_II_RELATIONSHIPS CIR

377: , csi_item_instances cii
378: , csi_instance_statuses iis
379: , asg_user asg
380: , csi_i_version_labels civ
381: , CSI_II_RELATIONSHIPS CIR
382: WHERE cii.inventory_item_id = cqa.inventory_item_id
383: AND cii.inv_organization_id = cqa.organization_id
384: AND cii.inv_subinventory_name = cqa.subinventory_code
385: AND ((cqa.LOCATOR_ID IS NULL AND cii.INV_LOCATOR_ID IS NULL)

Line 413: SELECT /*+ index(cii CSI_II_RELATIONSHIPS_U01) */acc.access_id,

409:
410: -- delete relationships for instances that no longer belong to the user
411: CURSOR l_itemrelationships_del1_csr
412: IS
413: SELECT /*+ index(cii CSI_II_RELATIONSHIPS_U01) */acc.access_id,
414: acc.user_id
415: --, acc.relationship_id
416: FROM csm_ii_relationships_acc acc,
417: csi_ii_relationships cii

Line 417: csi_ii_relationships cii

413: SELECT /*+ index(cii CSI_II_RELATIONSHIPS_U01) */acc.access_id,
414: acc.user_id
415: --, acc.relationship_id
416: FROM csm_ii_relationships_acc acc,
417: csi_ii_relationships cii
418: WHERE cii.relationship_id = acc.relationship_id
419: AND NOT EXISTS
420: (SELECT 1
421: FROM csm_item_instances_acc ins_acc

Line 435: FROM csi_ii_relationships cii

431: --,acc.relationship_id
432: FROM csm_ii_relationships_acc acc
433: WHERE NOT EXISTS
434: (SELECT 1
435: FROM csi_ii_relationships cii
436: WHERE cii.relationship_id = acc.relationship_id
437: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
438: );
439:

Line 449: csi_ii_relationships ii

445: acc.access_id,
446: ii.subject_id,
447: ii.object_id
448: FROM csm_ii_relationships_acc acc,
449: csi_ii_relationships ii
450: WHERE ii.relationship_id = acc.relationship_id
451: AND ii.last_update_date >= p_last_run_date;
452:
453: -- get new relationships for instances that the user has access to

Line 458: FROM csi_ii_relationships cii

454: --Bug 5184522
455: CURSOR l_itemrelationships_ins_csr(b_instance_id NUMBER,b_user_id NUMBER)
456: IS
457: SELECT DISTINCT cii.relationship_id
458: FROM csi_ii_relationships cii
459: WHERE cii.relationship_type_code = 'COMPONENT-OF'
460: AND (cii.object_id = b_instance_id OR cii.subject_id = b_instance_id)
461: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)
462: AND NOT EXISTS (SELECT 1 FROM CSM_II_RELATIONSHIPS_ACC ACC

Line 852: FROM CSI_II_RELATIONSHIPS

848:
849: CURSOR c_ib_parent_csr(p_instance_id IN number)
850: IS
851: SELECT object_id AS instance_id
852: FROM CSI_II_RELATIONSHIPS
853: WHERE RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
854: AND SUBJECT_ID = p_instance_id
855: AND SYSDATE BETWEEN nvl(active_start_date, SYSDATE)
856: AND nvl(active_end_date, SYSDATE)

Line 892: FROM CSI_II_RELATIONSHIPS

888: WHERE acc.user_id = p_user_id
889: AND acc.instance_id IN
890: (
891: SELECT subject_id
892: FROM CSI_II_RELATIONSHIPS
893: START WITH object_id = p_instance_id
894: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
895: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE)
896: AND NVL(active_end_date, SYSDATE)

Line 1089: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo

1085: AND iacc.incident_id = cia.incident_id
1086: AND cia.customer_product_id <> acc.instance_id
1087: AND NOT EXISTS
1088: (SELECT 1
1089: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo
1090: START WITH CIRo.OBJECT_ID = p_instance_id
1091: AND CIRo.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1092: AND SYSDATE BETWEEN NVL(CIRo.active_start_date, SYSDATE)
1093: AND NVL(CIRo.active_end_date, SYSDATE)