[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Shows the Orders placed for Transcripts and Enrollment Certificates. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT OHDR.ORDER_NUMBER
, OHDR.ORDER_DESCRIPTION
, '_LA:OHDR.ORDER_STATUS:IGS_LOOKUP_VALUES:IGS_AS_ORDER_STATUS:MEANING'
, OHDR.DATE_COMPLETED
, OHDR.ADDR_LINE_1
, OHDR.ADDR_LINE_2
, OHDR.ADDR_LINE_3
, OHDR.ADDR_LINE_4
, OHDR.CITY
, OHDR.STATE
, OHDR.PROVINCE
, OHDR.COUNTY
, OHDR.COUNTRY
, OHDR.POSTAL_CODE
, OHDR.EMAIL_ADDRESS
, OHDR.PHONE_COUNTRY_CODE
, OHDR.PHONE_AREA_CODE
, OHDR.PHONE_NUMBER
, OHDR.PHONE_EXTENSION
, OHDR.FAX_COUNTRY_CODE
, OHDR.FAX_AREA_CODE
, OHDR.FAX_NUMBER
, OHDR.DELIVERY_FEE
, OHDR.ORDER_FEE
, '_LA:OHDR.REQUEST_TYPE:IGS_LOOKUP_VALUES:IGS_AS_DOC_REQTYPE:MEANING'
, OHDR.SUBMIT_METHOD
, HP1.PARTY_NAME
, HP1.PARTY_NUMBER
, HP2.PARTY_NAME
, HP2.PARTY_NUMBER
, INVI.INVOICE_NUMBER
, INVI.INVOICE_DESC
, OHDR.PERSON_ID
, OHDR.ORDER_PLACED_BY
, OHDR.INVOICE_ID
, OHDR.CREATED_BY
, OHDR.CREATION_DATE
, OHDR.LAST_UPDATED_BY
, OHDR.LAST_UPDATE_DATE
FROM IGS_AS_ORDER_HDR OHDR
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, IGS_FI_INV_INT_ALL INVI
WHERE OHDR.PERSON_ID = HP1.PARTY_ID
AND OHDR.ORDER_PLACED_BY = HP2.PARTY_ID (+)
AND OHDR.INVOICE_ID = INVI.INVOICE_ID (+) WITH READ ONLY