eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_AS_DOCUMENT_ORDERS

Product:	IGS - Student System (Obsolete)
Description:	Shows the Orders placed for Transcripts and Enrollment Certificates.
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
ORDER_NUMBER
ORDER_DESCRIPTION
"_LA:ORDER_STATUS"
DATE_COMPLETED
ADDR_LINE_1
ADDR_LINE_2
ADDR_LINE_3
ADDR_LINE_4
CITY
STATE
PROVINCE
COUNTY
COUNTRY
POSTAL_CODE
EMAIL_ADDRESS
PHONE_COUNTRY_CODE
PHONE_AREA_CODE
PHONE_NUMBER
PHONE_EXTENSION
FAX_COUNTRY_CODE
FAX_AREA_CODE
FAX_NUMBER
DELIVERY_FEE
ORDER_FEE
"_LA:REQUEST_TYPE"
SUBMIT_METHOD
PERSON_NAME
PERSON_NUMBER
ORDER_PLACED_BY_NAME
ORDER_PLACED_BY_NUMBER
INVOICE_NUMBER
INVOICE_DESCRIPTION
PERSON_ID
ORDER_PLACED_BY
INVOICE_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE