VIEW: APPS.IGS_AS_ORDER_HDR_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)