Product: | OKS - Service Contracts |
---|---|
Description: | View is Used for Contracts Quote Printing |
Implementation/DBA Data: | APPS.OKS_HEADERS_V |
SELECT K.ID CONTRACT_ID
, K.CONTRACT_NUMBER CONTRACT_NUMBER
, NVL( K.CONTRACT_NUMBER_MODIFIER
, ' ') CONTRACT_MODIFIER
, K.START_DATE START_DATE
, K.END_DATE END_DATE
, K.STS_CODE STATUS
, K.SHORT_DESCRIPTION SHORT_DESCRIPTION
, PX.PARTY_ID PARTY_ID
, PX.PARTY_NUMBER PARTY_NUMBER
, PX.PARTY_NAME PARTY_NAME
, BTO.ADDRESS1 BILL2_ADDRESS1
, BTO.ADDRESS2 BILL2_ADDRESS2
, BTO.CITY||'
, '||BTO.STATE||' '||BTO.POSTAL_CODE BILL2_ADDRESS3
, BTO.COUNTRY BILL2_COUNTRY
, K.CURRENCY_CODE CURRENCY
, K.AUTHORING_ORG_ID ORG_ID
, K.INV_ORGANIZATION_ID INV_ORG_ID
, K.LAST_UPDATE_DATE LAST_UPDATE_DATE
, K.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
FROM OKC_K_HEADERS_V K
, OKC_K_PARTY_ROLES_V PR
, HZ_PARTIES PX
, OKX_CUST_SITE_USES_V BTO
WHERE PR.DNZ_CHR_ID = K.ID
AND PR.RLE_CODE = 'CUSTOMER'
AND PR.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND PX.PARTY_ID = TO_NUMBER( PR.OBJECT1_ID1)
AND PR.CHR_ID = K.ID
AND PR.CLE_ID IS NULL
AND K.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND BTO.ID1(+) = K.BILL_TO_SITE_USE_ID