APPS.CSM_SR_EVENT_PKG dependencies on CSI_ITEM_INSTANCES

Line 440: CSI_ITEM_INSTANCES CII

436: AND (b_htm5='N' OR LEVEL <=2) --for htm5 functionality
437: START WITH CIRo.OBJECT_ID = p_instance_id
438: CONNECT BY NOCYCLE CIRo.OBJECT_ID = PRIOR CIRo.SUBJECT_ID
439: ) CIR,
440: CSI_ITEM_INSTANCES CII
441: WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID
442: AND p_transaction_date BETWEEN NVL ( CII.ACTIVE_START_DATE , p_transaction_date )
443: AND NVL ( CII.ACTIVE_END_DATE , p_transaction_date)
444: UNION

Line 449: FROM csi_item_instances cii

445: -- select the current instance
446: SELECT l_null_relationship_id AS relationship_id,
447: cii.instance_id AS instance_id,
448: cii.inventory_item_id
449: FROM csi_item_instances cii
450: WHERE cii.instance_id = p_instance_id
451: AND p_transaction_date BETWEEN NVL(cii.active_start_date, p_transaction_date)
452: AND NVL(cii.active_end_date, p_transaction_date)
453: UNION

Line 458: csi_item_instances cii

454: SELECT cir.relationship_id AS relationship_id,
455: cir.object_id AS instance_id,
456: cii.inventory_item_id
457: FROM CSI_II_RELATIONSHIPS cir,
458: csi_item_instances cii
459: WHERE cir.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
460: AND cir.SUBJECT_ID = p_instance_id
461: AND cii.instance_id = cir.object_id
462: AND p_transaction_date BETWEEN NVL(cir.active_start_date, p_transaction_date)

Line 710: CSI_ITEM_INSTANCES CII

706: AND (b_htm5='N' OR LEVEL <=2) --for htm5 functionality SR1(A-B , B-C) & SR2(B-C,C-D) are downloaded. if no level for htm5, then SR1 will remove C-D as well
707: START WITH CIRo.OBJECT_ID = p_instance_id
708: CONNECT BY NOCYCLE CIRo.OBJECT_ID = PRIOR CIRo.SUBJECT_ID
709: ) CIR,
710: CSI_ITEM_INSTANCES CII
711: WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID
712: AND EXISTS(SELECT 1 FROM csm_ii_relationships_acc acc
713: where acc.relationship_id = cir.relationship_id
714: and acc.user_id=p_user_id)

Line 719: FROM csi_item_instances cii

715: UNION
716: SELECT l_null_relationship_id AS relationship_id,
717: p_instance_id AS instance_id,
718: cii.inventory_item_id
719: FROM csi_item_instances cii
720: WHERE cii.instance_id = p_instance_id
721: AND EXISTS(SELECT 1 FROM csm_item_instances_acc acc
722: where acc.instance_id =p_instance_id
723: and acc.user_id=p_user_id)

Line 730: csi_item_instances cii

726: SELECT cir.relationship_id as relationship_id,
727: cir.object_id AS instance_id,
728: cii.inventory_item_id
729: FROM CSI_II_RELATIONSHIPS cir,
730: csi_item_instances cii
731: WHERE cir.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
732: AND cir.SUBJECT_ID = p_instance_id
733: AND cii.instance_id = cir.object_id
734: AND EXISTS(SELECT 1 FROM csm_ii_relationships_acc acc