CA_DTL_BUNDL_VW

(SQL View)
Index Back

Contracts Bundle Vw

Contracts Bundle View

SELECT DISTINCT BUSINESS_UNIT , BUNDLE_OFFERING FROM PS_CA_CONTR_HDR HDR , PS_CA_DETAIL DTL WHERE HDR.CONTRACT_NUM = DTL.CONTRACT_NUM AND (BUNDLE_OFFERING IS NOT NULL AND BUNDLE_OFFERING <>' ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUNDLE_OFFERING Character(20) VARCHAR2(20) NOT NULL Bundle