VIEW: APPS.OKL_CS_LC_HEADER_UV

Source

View Text - Preformatted

SELECT CHR.contract_number contract_number, PDT.name product_name, STST.MEANING contract_status, CHR.start_date start_date, CHR.end_date end_date, CHRT.description Description, chr.cust_po_number, HZP.PERSON_NAME_SUFFIX ||' '||HZP.person_first_name||' '||HZP.person_middle_name||' '||HZP.person_last_name contact_person, HZP.person_title title, HZP.PARTY_NAME customer, HZP.ORGANIZATION_NAME_PHONETIC organization_name_phonetic, HZP.address1||' '||hzp.address2||' '||hzp.address3||hzp.address4||','||hzp.city||','||hzp.country||' '||hzp.postal_code address, HCP.phone_country_code phone_country, HCP.phone_area_code Phone_Area, HCP.phone_number Phone_number , HCP.phone_extension phone_extension, HCP.telex_number Fax_number, HZP.email_address email, CHR.INV_ORGANIZATION_ID org_id, CHR.ID contract_id, CHR.CURRENCY_CODE currency_code, HZP.party_id party_id, HCA.cust_account_id cust_account_id FROM OKC_K_HEADERS_TL CHRT,OKC_K_HEADERS_B CHR,OKL_K_HEADERS KHR,OKC_STATUSES_TL STST,OKL_PRODUCTS PDT,HZ_CUST_ACCOUNTS HCA,HZ_PARTIES HZP,HZ_CONTACT_POINTS HCP WHERE CHRT.ID = CHR.ID AND CHRT.LANGUAGE = USERENV('LANG') AND CHR.ID = KHR.ID AND KHR.PDT_ID = PDT.ID(+) AND CHR.STS_CODE = STST.CODE AND STST.LANGUAGE = USERENV('LANG') AND CHR.cust_acct_id = HCA.cust_account_id AND HCA.PARTY_ID = HZP.PARTY_ID AND HZP.party_id = HCP.owner_table_id(+) AND HCP.owner_table_name(+) = 'HZ_PARTIES' AND HCP.status(+) = 'A' AND HCP.PRIMARY_FLAG(+) = 'Y' AND HCP.CONTACT_POINT_TYPE(+) = 'PHONE'

View Text - HTML Formatted

SELECT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, PDT.NAME PRODUCT_NAME
, STST.MEANING CONTRACT_STATUS
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, CHRT.DESCRIPTION DESCRIPTION
, CHR.CUST_PO_NUMBER
, HZP.PERSON_NAME_SUFFIX ||' '||HZP.PERSON_FIRST_NAME||' '||HZP.PERSON_MIDDLE_NAME||' '||HZP.PERSON_LAST_NAME CONTACT_PERSON
, HZP.PERSON_TITLE TITLE
, HZP.PARTY_NAME CUSTOMER
, HZP.ORGANIZATION_NAME_PHONETIC ORGANIZATION_NAME_PHONETIC
, HZP.ADDRESS1||' '||HZP.ADDRESS2||' '||HZP.ADDRESS3||HZP.ADDRESS4||'
, '||HZP.CITY||'
, '||HZP.COUNTRY||' '||HZP.POSTAL_CODE ADDRESS
, HCP.PHONE_COUNTRY_CODE PHONE_COUNTRY
, HCP.PHONE_AREA_CODE PHONE_AREA
, HCP.PHONE_NUMBER PHONE_NUMBER
, HCP.PHONE_EXTENSION PHONE_EXTENSION
, HCP.TELEX_NUMBER FAX_NUMBER
, HZP.EMAIL_ADDRESS EMAIL
, CHR.INV_ORGANIZATION_ID ORG_ID
, CHR.ID CONTRACT_ID
, CHR.CURRENCY_CODE CURRENCY_CODE
, HZP.PARTY_ID PARTY_ID
, HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
FROM OKC_K_HEADERS_TL CHRT
, OKC_K_HEADERS_B CHR
, OKL_K_HEADERS KHR
, OKC_STATUSES_TL STST
, OKL_PRODUCTS PDT
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HZP
, HZ_CONTACT_POINTS HCP
WHERE CHRT.ID = CHR.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHR.ID = KHR.ID
AND KHR.PDT_ID = PDT.ID(+)
AND CHR.STS_CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')
AND CHR.CUST_ACCT_ID = HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = HZP.PARTY_ID
AND HZP.PARTY_ID = HCP.OWNER_TABLE_ID(+)
AND HCP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HCP.STATUS(+) = 'A'
AND HCP.PRIMARY_FLAG(+) = 'Y'
AND HCP.CONTACT_POINT_TYPE(+) = 'PHONE'