SELECT traveler_config.traveler_id, traveler_config.rev_no, hold_point, MAX(traveler_page) as REVMAXPAGE
FROM ( #application.schema#.traveler_config
INNER JOIN #application.schema#.traveler_tables ON traveler_config.traveler_id=traveler_tables.traveler_id AND traveler_config.rev_no=traveler_tables.rev_no)
WHERE traveler_config.traveler_id='#url.traveler#'
GROUP BY traveler_config.traveler_id,traveler_config.rev_no,hold_point
SELECT rev_no
FROM #application.schema#.traveler_config
WHERE traveler_id='#url.traveler#' and obs is NULL
SELECT traveler_id, traveler_seq_num, rev_no
FROM #application.schema#.traveler_config
WHERE traveler_id LIKE '#url.area#-NCR' AND obs is NULL
#url.project#
Data View
SELECT rev_no
FROM #application.schema#.traveler_owners
WHERE traveler_id LIKE '#url.area#-NCR' AND traveler_seq_num='#url.ncr_num#'
NCR link
SELECT traveler_config.traveler_id, traveler_config.rev_no, hold_point, MAX(traveler_page) as REVMAXPAGE
FROM ( #application.schema#.traveler_config
INNER JOIN #application.schema#.traveler_tables ON traveler_config.traveler_id=traveler_tables.traveler_id AND traveler_config.rev_no=traveler_tables.rev_no)
WHERE traveler_config.traveler_id='#url.traveler#'
GROUP BY traveler_config.traveler_id,traveler_config.rev_no,hold_point
SELECT rev_no
FROM #application.schema#.traveler_config
WHERE traveler_id='#url.traveler#' and obs is NULL
SELECT traveler_id, traveler_seq_num, rev_no
FROM #application.schema#.traveler_config
WHERE traveler_id LIKE '#url.area#-NCR' AND obs is NULL
SerialNum: #url.serialnum#
#TRAVELER#
#REVNUM#
Pg:#PAGE#
SeqNum: #sequence_number#
There is a hold point in effect. Processing of this traveler can not continue without
supervisor approval.
There is a hold point in effect. Processing of this traveler can not continue without
supervisor approval.
