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 120: FROM CSI_II_RELATIONSHIPS CIR

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

Line 380: , CSI_II_RELATIONSHIPS CIR

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

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

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

Line 419: csi_ii_relationships cii

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

Line 436: csi_ii_relationships cii

432: acc.user_id,
433: cii.subject_id
434: --,acc.relationship_id
435: FROM csm_ii_relationships_acc acc,
436: csi_ii_relationships cii
437: WHERE cii.relationship_id = acc.relationship_id
438: AND NVL(cii.active_end_date, SYSDATE) < SYSDATE;
439:
440: -- update existing relationships

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 460: FROM csi_ii_relationships cii,

456: SELECT iacc.user_id,
457: cii.relationship_id,
458: cii.subject_id,
459: cii.object_id
460: FROM csi_ii_relationships cii,
461: csm_item_instances_acc iacc
462: WHERE cii.relationship_type_code = 'COMPONENT-OF'
463: AND cii.object_id = iacc.instance_id
464: AND SYSDATE BETWEEN NVL(cii.active_start_date, SYSDATE) AND NVL(cii.active_end_date, SYSDATE)

Line 795: FROM CSI_II_RELATIONSHIPS

791:
792: CURSOR c_ib_parent_csr(p_instance_id IN number)
793: IS
794: SELECT object_id AS instance_id
795: FROM CSI_II_RELATIONSHIPS
796: WHERE RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
797: AND SUBJECT_ID = p_instance_id
798: AND SYSDATE BETWEEN nvl(active_start_date, SYSDATE)
799: AND nvl(active_end_date, SYSDATE)

Line 836: FROM CSI_II_RELATIONSHIPS

832: WHERE acc.user_id = p_user_id
833: AND acc.instance_id IN
834: (
835: SELECT subject_id
836: FROM CSI_II_RELATIONSHIPS
837: START WITH object_id = p_instance_id
838: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
839: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE)
840: AND NVL(active_end_date, SYSDATE)

Line 1048: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo

1044: AND iacc.incident_id = cia.incident_id
1045: AND cia.customer_product_id <> acc.instance_id
1046: AND NOT EXISTS
1047: (SELECT 1
1048: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo
1049: START WITH CIRo.OBJECT_ID = p_instance_id
1050: AND CIRo.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1051: AND SYSDATE BETWEEN NVL(CIRo.active_start_date, SYSDATE)
1052: AND NVL(CIRo.active_end_date, SYSDATE)