APPS.AHL_PRD_NONROUTINE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 1480: AND not exists (select 'x' from csi_ii_relationships

1476: WHERE csi.instance_id = c_instance_id
1477: AND csi.wip_job_id = WO.WIP_ENTITY_ID
1478: AND wo.workorder_id = c_wo_id
1479: AND csi.location_type_code = 'WIP'
1480: AND not exists (select 'x' from csi_ii_relationships
1481: where subject_id = csi.instance_id
1482: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1483: AND TRUNC(NVL(ACTIVE_START_DATE, SYSDATE)) <= TRUNC(SYSDATE)
1484: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE));