Product: | IGS - Student System |
---|---|
Description: | This view stores the document order information. This will store the information like student address, order status, payment type information related to the document request. One order can have multiple documents associated with the order. |
Implementation/DBA Data: | APPS.IGS_AS_ORDER_HDR_V |
SELECT HDR.ROWID
, HDR.ORDER_NUMBER
, HDR.ORDER_STATUS
, LK.MEANING
, HDR.DATE_COMPLETED
, HDR.PERSON_ID
, HDR.ADDR_LINE_1
, HDR.ADDR_LINE_2
, HDR.ADDR_LINE_3
, HDR.ADDR_LINE_4
, HDR.CITY
, HDR.STATE
, HDR.PROVINCE
, HDR.COUNTY
, HDR.COUNTRY
, TR.TERRITORY_SHORT_NAME
, HDR.POSTAL_CODE
, HDR.EMAIL_ADDRESS
, HDR.PHONE_COUNTRY_CODE
, HDR.PHONE_AREA_CODE
, HDR.PHONE_NUMBER
, HDR.PHONE_EXTENSION
, HDR.FAX_COUNTRY_CODE
, HDR.FAX_AREA_CODE
, HDR.FAX_NUMBER
, HDR.DELIVERY_FEE
, HDR.ORDER_FEE
, HDR.REQUEST_TYPE
, LK2.MEANING
, HDR.SUBMIT_METHOD
, HDR.INVOICE_ID
, HDR.CREATED_BY
, HDR.CREATION_DATE
, HDR.LAST_UPDATED_BY
, HDR.LAST_UPDATE_DATE
, HDR.LAST_UPDATE_LOGIN
, HDR.PROGRAM_APPLICATION_ID
, HDR.REQUEST_ID
, HDR.PROGRAM_ID
, HDR.PROGRAM_UPDATE_DATE
, ORDER_PLACED_BY
, ORDER_DESCRIPTION
, IGS_AS_SS_DOC_REQUEST.IS_ORDER_DEL_ALWD (HDR.ORDER_NUMBER)
, PE.PARTY_NAME
FROM IGS_AS_ORDER_HDR HDR
, FND_TERRITORIES_TL TR
, FND_LOOKUP_VALUES LK
, FND_LOOKUP_VALUES LK2
, HZ_PARTIES PE
WHERE HDR.COUNTRY = TR.TERRITORY_CODE
AND TR.LANGUAGE = USERENV ('LANG')
AND HDR.ORDER_STATUS = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'IGS_AS_ORDER_STATUS'
AND LK.LANGUAGE = USERENV ('LANG')
AND LK.VIEW_APPLICATION_ID = 8405
AND LK.SECURITY_GROUP_ID = 0
AND HDR.REQUEST_TYPE = LK2.LOOKUP_CODE (+)
AND LK2.LOOKUP_TYPE (+) = 'IGS_AS_DOC_REQTYPE'
AND LK2.LANGUAGE (+) = USERENV ('LANG')
AND LK2.VIEW_APPLICATION_ID (+) = 8405
AND LK2.SECURITY_GROUP_ID (+) = 0
AND HDR.ORDER_PLACED_BY = PE.PARTY_ID (+)