VIEW: APPS.IGC_CC_CLOSED_CANC_HDRS_V

Source

View Text - Preformatted

SELECT DATE_V.cc_hdr_id cc_hd_id, ICH.cc_num cc_num_val, ICAL.cc_acct_line_id cc_act_id, ICDP.cc_det_pf_line_id cc_pf_id, DATE_V.max_activity_date max_dt FROM igc_cc_headers ICH, IGC_CC_HDRS_MAX_DATES_V DATE_V, igc_cc_acct_lines ICAL, igc_cc_det_pf ICDP WHERE ICH.cc_header_id = DATE_V.cc_hdr_id AND ICH.cc_state IN ('CL', 'CT') AND ICH.cc_apprvl_status = 'AP' AND DATE_V.cc_hdr_id = ICAL.cc_header_id AND ICAL.cc_acct_line_id = ICDP.cc_acct_line_id

View Text - HTML Formatted

SELECT DATE_V.CC_HDR_ID CC_HD_ID
, ICH.CC_NUM CC_NUM_VAL
, ICAL.CC_ACCT_LINE_ID CC_ACT_ID
, ICDP.CC_DET_PF_LINE_ID CC_PF_ID
, DATE_V.MAX_ACTIVITY_DATE MAX_DT
FROM IGC_CC_HEADERS ICH
, IGC_CC_HDRS_MAX_DATES_V DATE_V
, IGC_CC_ACCT_LINES ICAL
, IGC_CC_DET_PF ICDP
WHERE ICH.CC_HEADER_ID = DATE_V.CC_HDR_ID
AND ICH.CC_STATE IN ('CL'
, 'CT')
AND ICH.CC_APPRVL_STATUS = 'AP'
AND DATE_V.CC_HDR_ID = ICAL.CC_HEADER_ID
AND ICAL.CC_ACCT_LINE_ID = ICDP.CC_ACCT_LINE_ID