APPS.AHL_PRD_NONROUTINE_PVT dependencies on CSI_II_RELATIONSHIPS

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

1328: WHERE csi.instance_id = c_instance_id
1329: AND csi.wip_job_id = WO.WIP_ENTITY_ID
1330: AND wo.workorder_id = c_wo_id
1331: AND csi.location_type_code = 'WIP'
1332: AND not exists (select 'x' from csi_ii_relationships
1333: where subject_id = csi.instance_id
1334: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1335: AND TRUNC(NVL(ACTIVE_START_DATE, SYSDATE)) <= TRUNC(SYSDATE)
1336: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE));