VIEW: APPS.IGSFV_AS_DOCUMENT_ORDERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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