DBA Data[Home] [Help]

APPS.CSM_SR_EVENT_PKG dependencies on CSI_ITEM_INSTANCES

Line 424: CURSOR l_instance_children_csr (p_instance_id csi_item_instances.instance_id%TYPE,

420: l_organization_id NUMBER;
421:
422: -- get all the child intances of the parent and the parent instance
423: -- also check these instances do not exist for the user
424: CURSOR l_instance_children_csr (p_instance_id csi_item_instances.instance_id%TYPE,
425: p_transaction_date DATE, p_user_id fnd_user.user_id%TYPE)
426: IS
427: SELECT cir.relationship_id AS relationship_id ,
428: cir.subject_id AS instance_id ,

Line 437: CSI_ITEM_INSTANCES CII

433: AND p_transaction_date BETWEEN NVL(CIRo.active_start_date, p_transaction_date)
434: AND NVL(CIRo.active_end_date, p_transaction_date)
435: CONNECT BY CIRo.OBJECT_ID = PRIOR CIRo.SUBJECT_ID
436: ) CIR,
437: CSI_ITEM_INSTANCES CII
438: WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID
439: AND p_transaction_date BETWEEN NVL ( CII.ACTIVE_START_DATE , p_transaction_date )
440: AND NVL ( CII.ACTIVE_END_DATE , p_transaction_date)
441: UNION

Line 446: FROM csi_item_instances cii

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

Line 455: csi_item_instances cii

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

Line 689: CURSOR l_parent_child_instance_csr (p_instance_id csi_item_instances.instance_id%type,

685: l_null_relationship_id csi_ii_relationships.relationship_id%TYPE;
686: l_organization_id NUMBER;
687:
688: -- get all the child instances of the parent instance as well as the parent
689: CURSOR l_parent_child_instance_csr (p_instance_id csi_item_instances.instance_id%type,
690: p_transaction_date date)
691: IS
692: SELECT cir.relationship_id AS relationship_id ,
693: cir.subject_id AS instance_id ,

Line 702: CSI_ITEM_INSTANCES CII

698: AND p_transaction_date BETWEEN NVL(CIRo.active_start_date, p_transaction_date)
699: AND NVL(CIRo.active_end_date, p_transaction_date)
700: CONNECT BY CIRo.OBJECT_ID = PRIOR CIRo.SUBJECT_ID
701: ) CIR,
702: CSI_ITEM_INSTANCES CII
703: WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID
704: AND p_transaction_date BETWEEN NVL ( CII.ACTIVE_START_DATE , p_transaction_date )
705: AND NVL ( CII.ACTIVE_END_DATE , p_transaction_date)
706: UNION

Line 710: FROM csi_item_instances cii

706: UNION
707: SELECT l_null_relationship_id AS relationship_id,
708: p_instance_id AS instance_id,
709: cii.inventory_item_id
710: FROM csi_item_instances cii
711: WHERE cii.instance_id = p_instance_id
712: AND p_transaction_date BETWEEN NVL(cii.active_start_date, p_transaction_date)
713: AND NVL(cii.active_end_date, p_transaction_date)
714: -- get the parent instance

Line 720: csi_item_instances cii

716: SELECT cir.relationship_id as relationship_id,
717: cir.object_id AS instance_id,
718: cii.inventory_item_id
719: FROM CSI_II_RELATIONSHIPS cir,
720: csi_item_instances cii
721: WHERE cir.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
722: AND cir.SUBJECT_ID = p_instance_id
723: AND cii.instance_id = cir.object_id
724: AND p_transaction_date BETWEEN NVL(cir.active_start_date, p_transaction_date)