VIEW: APPS.BIC_CONTRACT_MEASURES_V

Source

View Text - Preformatted

SELECT con.id renewed_contract_id, to_number(par.object1_id1) party_id, con.estimated_amount contract_amount, con.currency_code currency_code, con.start_date start_date_active, con.end_date end_date_active, con.date_renewed, con.sts_code status, con.authoring_org_id org_id FROM okc_k_headers_b con, okc_k_party_roles_b par WHERE con.id=par.chr_id and con.template_yn='N' and par.jtot_object1_code='OKX_PARTY' and par.rle_code='CUSTOMER' and par.cle_id IS NULL

View Text - HTML Formatted

SELECT CON.ID RENEWED_CONTRACT_ID
, TO_NUMBER(PAR.OBJECT1_ID1) PARTY_ID
, CON.ESTIMATED_AMOUNT CONTRACT_AMOUNT
, CON.CURRENCY_CODE CURRENCY_CODE
, CON.START_DATE START_DATE_ACTIVE
, CON.END_DATE END_DATE_ACTIVE
, CON.DATE_RENEWED
, CON.STS_CODE STATUS
, CON.AUTHORING_ORG_ID ORG_ID
FROM OKC_K_HEADERS_B CON
, OKC_K_PARTY_ROLES_B PAR
WHERE CON.ID=PAR.CHR_ID
AND CON.TEMPLATE_YN='N'
AND PAR.JTOT_OBJECT1_CODE='OKX_PARTY'
AND PAR.RLE_CODE='CUSTOMER'
AND PAR.CLE_ID IS NULL