APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_II_RELATIONSHIPS

Line 3357: FROM csi_ii_relationships

3353: -- Check if relationships is already been built then allow update
3354: BEGIN
3355: SELECT 'Y',subject_id,object_id,relationship_type_code
3356: INTO l_relationship_exists,l_subject_id,l_object_id,l_relationship_type_code
3357: FROM csi_ii_relationships
3358: WHERE relationship_type_code = 'COMPONENT-OF'
3359: AND nvl(active_end_date, sysdate + 1) >= sysdate
3360: AND (object_id = p_instance_rec.instance_id OR
3361: subject_id = p_instance_rec.instance_id );

Line 3376: l_root_asset_id := csi_ii_relationships_pvt.Get_Root_Parent(l_subject_id,

3372: csi_gen_utility_pvt.put_line('The Subject Id '||l_subject_id);
3373: csi_gen_utility_pvt.put_line('The Object Id '||l_object_id);
3374: csi_gen_utility_pvt.put_line('The relationship_type_code '||l_relationship_type_code);
3375:
3376: l_root_asset_id := csi_ii_relationships_pvt.Get_Root_Parent(l_subject_id,
3377: l_relationship_type_code,
3378: l_object_id);
3379:
3380: CSI_BUSINESS_EVENT_PVT.UPDATE_INSTANCE_EVENT

Line 6803: FROM csi_ii_relationships

6799: /*
6800: SELECT 'x' INTO l_exists
6801: FROM dual
6802: WHERE EXISTS (SELECT 'x'
6803: FROM csi_ii_relationships
6804: WHERE object_id = p_instance_rec.instance_id
6805: AND relationship_type_code = 'COMPONENT-OF'
6806: AND NVL (active_end_date,(sysdate+1)) > sysdate);
6807: */

Line 6810: FROM csi_ii_relationships

6806: AND NVL (active_end_date,(sysdate+1)) > sysdate);
6807: */
6808: SELECT 'x'
6809: INTO l_exists
6810: FROM csi_ii_relationships
6811: WHERE object_id = p_instance_rec.instance_id
6812: AND relationship_type_code = 'COMPONENT-OF'
6813: AND NVL (active_end_date,(sysdate+1)) > sysdate
6814: AND ROWNUM=1;