CA_WC_PRCADJ_LG (SQL View)	Index Back
Undoc Price Adjustments Lang The language record for the view that lists the contracts which have a difference between the total billing and total revenue that has not been documented

CA_WC_PRCADJ_LG

(SQL View)

Undoc Price Adjustments Lang

The language record for the view that lists the contracts which have a difference between the total billing and total revenue that has not been documented

SELECT HDR.CONTRACT_NUM ,CUST.LANGUAGE_CD ,CUST.NAME1 AS CUSTOMER_NAME FROM PS_SET_CNTRL_REC SCNTL , PS_CA_CONTR_HDR HDR , PS_CUSTOMER_LANG CUST WHERE SCNTL.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND SCNTL.RECNAME = 'CUSTOMER' AND SCNTL.SETID = CUST.SETID AND HDR.SOLD_TO_CUST_ID = CUST.CUST_ID

Related Language Record for CA_WC_PRCADJ_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name