VIEW: APPS.IGS_DA_WIFFTR_V

Source

View Text - Preformatted

SELECT pr.batch_id, pr.program_code, tr.track_seq_num, mj.major_seq_num, tr.track_unit_set, tr.track_option_version, tr.track_option_catalog, tr.org_unit_track, tr.track_cal_type, tr.track_ci_seq_num, mn1.minor_unit_set minor_unit_set1 , mn1.minor_version , mn1.minor_catalog , mn1.org_unit_minor , mn1.minor_cal_type , mn1.minor_ci_seq_num , mn2.minor_unit_set minor_unit_set2 , mn2.minor_version , mn2.minor_catalog , mn2.org_unit_minor , mn2.minor_cal_type , mn2.minor_ci_seq_num , mn3.minor_unit_set minor_unit_set3 , mn3.minor_version , mn3.minor_catalog , mn3.org_unit_minor , mn3.minor_cal_type , mn3.minor_ci_seq_num, mj.major_unit_set, mj.major_version, mj.major_catalog, mj.org_unit_major, mj.major_cal_type, mj.major_ci_seq_num, pr.program_version FROM IGS_DA_REQ_WIFPRGS pr, IGS_DA_REQ_WIFMJRS mj, IGS_DA_REQ_WIFMNRS mn1, IGS_DA_REQ_WIFMNRS mn2, IGS_DA_REQ_WIFMNRS mn3, IGS_DA_REQ_WIFTRCKS tr WHERE pr.batch_id = mj.batch_id AND mj.batch_id = mn1.batch_id(+) AND mj.batch_id = mn2.batch_id(+) AND mj.batch_id = mn3.batch_id(+) AND mj.major_seq_num = mn1.major_seq_num(+) AND mj.major_seq_num = mn2.major_seq_num(+) AND mj.major_seq_num = mn3.major_seq_num(+) AND mj.major_seq_num = tr.major_seq_num(+) AND mn1.minor_seq_num(+) = 1 AND mn2.minor_seq_num(+) = 2 AND mn3.minor_seq_num(+) = 3 AND mj.batch_id = tr.batch_id(+) UNION SELECT pr.batch_id, pr.program_code, tr.track_seq_num, tr.major_seq_num, tr.track_unit_set, tr.track_option_version, tr.track_option_catalog, tr.org_unit_track, tr.track_cal_type, tr.track_ci_seq_num, mn1.minor_unit_set minor_unit_set1, mn1.minor_version minor_version1, mn1.minor_catalog minor_catalog1, mn1.org_unit_minor org_unit_minor1, mn1.minor_cal_type minor_cal_type1, mn1.minor_ci_seq_num minor_ci_seq_num1, mn2.minor_unit_set minor_unit_set2, mn2.minor_version minor_version2, mn2.minor_catalog minor_catalog2, mn2.org_unit_minor org_unit_minor2, mn2.minor_cal_type minor_cal_type2, mn2.minor_ci_seq_num minor_ci_seq_num2, mn3.minor_unit_set minor_unit_set3, mn3.minor_version minor_version3, mn3.minor_catalog minor_catalog3, mn3.org_unit_minor org_unit_minor3, mn3.minor_cal_type minor_cal_type3, mn3.minor_ci_seq_num minor_ci_seq_num3, '', to_number(null), '', '', '', to_number(null), pr.program_version FROM IGS_DA_REQ_WIFPRGS pr, IGS_DA_REQ_WIFMNRS mn1, IGS_DA_REQ_WIFMNRS mn2, IGS_DA_REQ_WIFMNRS mn3, IGS_DA_REQ_WIFTRCKS tr WHERE pr.batch_id = mn1.batch_id(+) AND pr.batch_id = mn2.batch_id(+) AND pr.batch_id = mn3.batch_id(+) AND mn1.minor_seq_num(+) = 1 AND mn2.minor_seq_num(+) = 2 AND mn3.minor_seq_num(+) = 3 AND pr.batch_id = tr.batch_id(+) AND NOT EXISTS (SELECT 1 FROM igs_da_req_wifmjrs mj WHERE pr.batch_id = mj.batch_id )

View Text - HTML Formatted

SELECT PR.BATCH_ID
, PR.PROGRAM_CODE
, TR.TRACK_SEQ_NUM
, MJ.MAJOR_SEQ_NUM
, TR.TRACK_UNIT_SET
, TR.TRACK_OPTION_VERSION
, TR.TRACK_OPTION_CATALOG
, TR.ORG_UNIT_TRACK
, TR.TRACK_CAL_TYPE
, TR.TRACK_CI_SEQ_NUM
, MN1.MINOR_UNIT_SET MINOR_UNIT_SET1
, MN1.MINOR_VERSION
, MN1.MINOR_CATALOG
, MN1.ORG_UNIT_MINOR
, MN1.MINOR_CAL_TYPE
, MN1.MINOR_CI_SEQ_NUM
, MN2.MINOR_UNIT_SET MINOR_UNIT_SET2
, MN2.MINOR_VERSION
, MN2.MINOR_CATALOG
, MN2.ORG_UNIT_MINOR
, MN2.MINOR_CAL_TYPE
, MN2.MINOR_CI_SEQ_NUM
, MN3.MINOR_UNIT_SET MINOR_UNIT_SET3
, MN3.MINOR_VERSION
, MN3.MINOR_CATALOG
, MN3.ORG_UNIT_MINOR
, MN3.MINOR_CAL_TYPE
, MN3.MINOR_CI_SEQ_NUM
, MJ.MAJOR_UNIT_SET
, MJ.MAJOR_VERSION
, MJ.MAJOR_CATALOG
, MJ.ORG_UNIT_MAJOR
, MJ.MAJOR_CAL_TYPE
, MJ.MAJOR_CI_SEQ_NUM
, PR.PROGRAM_VERSION
FROM IGS_DA_REQ_WIFPRGS PR
, IGS_DA_REQ_WIFMJRS MJ
, IGS_DA_REQ_WIFMNRS MN1
, IGS_DA_REQ_WIFMNRS MN2
, IGS_DA_REQ_WIFMNRS MN3
, IGS_DA_REQ_WIFTRCKS TR
WHERE PR.BATCH_ID = MJ.BATCH_ID
AND MJ.BATCH_ID = MN1.BATCH_ID(+)
AND MJ.BATCH_ID = MN2.BATCH_ID(+)
AND MJ.BATCH_ID = MN3.BATCH_ID(+)
AND MJ.MAJOR_SEQ_NUM = MN1.MAJOR_SEQ_NUM(+)
AND MJ.MAJOR_SEQ_NUM = MN2.MAJOR_SEQ_NUM(+)
AND MJ.MAJOR_SEQ_NUM = MN3.MAJOR_SEQ_NUM(+)
AND MJ.MAJOR_SEQ_NUM = TR.MAJOR_SEQ_NUM(+)
AND MN1.MINOR_SEQ_NUM(+) = 1
AND MN2.MINOR_SEQ_NUM(+) = 2
AND MN3.MINOR_SEQ_NUM(+) = 3
AND MJ.BATCH_ID = TR.BATCH_ID(+) UNION SELECT PR.BATCH_ID
, PR.PROGRAM_CODE
, TR.TRACK_SEQ_NUM
, TR.MAJOR_SEQ_NUM
, TR.TRACK_UNIT_SET
, TR.TRACK_OPTION_VERSION
, TR.TRACK_OPTION_CATALOG
, TR.ORG_UNIT_TRACK
, TR.TRACK_CAL_TYPE
, TR.TRACK_CI_SEQ_NUM
, MN1.MINOR_UNIT_SET MINOR_UNIT_SET1
, MN1.MINOR_VERSION MINOR_VERSION1
, MN1.MINOR_CATALOG MINOR_CATALOG1
, MN1.ORG_UNIT_MINOR ORG_UNIT_MINOR1
, MN1.MINOR_CAL_TYPE MINOR_CAL_TYPE1
, MN1.MINOR_CI_SEQ_NUM MINOR_CI_SEQ_NUM1
, MN2.MINOR_UNIT_SET MINOR_UNIT_SET2
, MN2.MINOR_VERSION MINOR_VERSION2
, MN2.MINOR_CATALOG MINOR_CATALOG2
, MN2.ORG_UNIT_MINOR ORG_UNIT_MINOR2
, MN2.MINOR_CAL_TYPE MINOR_CAL_TYPE2
, MN2.MINOR_CI_SEQ_NUM MINOR_CI_SEQ_NUM2
, MN3.MINOR_UNIT_SET MINOR_UNIT_SET3
, MN3.MINOR_VERSION MINOR_VERSION3
, MN3.MINOR_CATALOG MINOR_CATALOG3
, MN3.ORG_UNIT_MINOR ORG_UNIT_MINOR3
, MN3.MINOR_CAL_TYPE MINOR_CAL_TYPE3
, MN3.MINOR_CI_SEQ_NUM MINOR_CI_SEQ_NUM3
, ''
, TO_NUMBER(NULL)
, ''
, ''
, ''
, TO_NUMBER(NULL)
, PR.PROGRAM_VERSION
FROM IGS_DA_REQ_WIFPRGS PR
, IGS_DA_REQ_WIFMNRS MN1
, IGS_DA_REQ_WIFMNRS MN2
, IGS_DA_REQ_WIFMNRS MN3
, IGS_DA_REQ_WIFTRCKS TR
WHERE PR.BATCH_ID = MN1.BATCH_ID(+)
AND PR.BATCH_ID = MN2.BATCH_ID(+)
AND PR.BATCH_ID = MN3.BATCH_ID(+)
AND MN1.MINOR_SEQ_NUM(+) = 1
AND MN2.MINOR_SEQ_NUM(+) = 2
AND MN3.MINOR_SEQ_NUM(+) = 3
AND PR.BATCH_ID = TR.BATCH_ID(+)
AND NOT EXISTS (SELECT 1
FROM IGS_DA_REQ_WIFMJRS MJ
WHERE PR.BATCH_ID = MJ.BATCH_ID )