Selecting a job stream with carry forward on / off is a bit challenging as there is no out of the box option, the simplest method is to use direct SQL queries as below:
where:
<TWS DB user> --> the DB user for TWS schema
<FTA name> --> FTA name (eider full or partial, % is a wild card like @)
CF.JST_CARRY_FORWARD = 'N' --> jobs streams without CF, and 'Y' with
alter session set current_schema=<TWS DB user>;
SELECT DISTINCT WKS.WKS_NAME, STREAM.AJS_NAME, CF.JST_CARRY_FORWARD
FROM WKS_WORKSTATIONS WKS, AJS_ABSTRACT_JOB_STREAMS STREAM, JST_JOB_STREAMS CF
WHERE WKS.WKC_ID=STREAM.WKC_ID AND WKS.WKS_NAME like '%<FTA name>%' AND
STREAM.AJS_ID=CF.AJS_ID AND CF.JST_CARRY_FORWARD = 'N'
where:
<TWS DB user> --> the DB user for TWS schema
<FTA name> --> FTA name (eider full or partial, % is a wild card like @)
CF.JST_CARRY_FORWARD = 'N' --> jobs streams without CF, and 'Y' with
Superb!!
ReplyDeleteblogs are an extraordinary approach to interface with individuals and give valuable data. You can accomplish that in this post. A debt of gratitude is in order for sharing this.In the event that you have to make a quality custom research project, consider a similar alternative and search for the best proficient paper writing service, for example, custom essay writing service.
ReplyDelete