RO_ORD_REVNB_VW

(SQL View)
Index Back

Enterprise Order Revenue

Input view for Enterprise Order Revenue ACE report. The view is for all business units.

SELECT DISTINCT A.PROBINST , A.CAPTURE_ID , A.BUSINESS_UNIT , A.SETID_STATUS , A.SETID_SOURCE , A.SETID_CAPTURE_TYPE , A.EFFDT , A.STATUS_CD_STR , A.SOURCE_CD , A.CAPTURE_TYPE_CD , A.CURRENCY_CD , A.BAM_DATE , B.REGION_ID , A.TOTAL_PRICE , A.TOTAL_COUNT , CASE WHEN C.TOTAL_COUNT IS NULL THEN 0 ELSE C.TOTAL_COUNT END FROM PS_RO_ORD_REBUS_VW A , PS_RO_SLD_2_RGN_VW B , PS_RO_QUO_CONV_VW C WHERE A.PROBINST = B.PROBINST(+) AND A.CAPTURE_ID = B.CAPTURE_ID(+) AND A.PROBINST = C.PROBINST(+) AND A.CAPTURE_ID = C.CAPTURE_ID(+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RO_NONVW

4 SETID_STATUS Character(5) VARCHAR2(5) NOT NULL MOC SETID Field
5 SETID_SOURCE Character(5) VARCHAR2(5) NOT NULL MOC SETID Field
6 SETID_CAPTURE_TYPE Character(5) VARCHAR2(5) NOT NULL MOC SETID Field
7 EFFDT Date(10) DATE Effective Date

Default Value: %date

8 STATUS_CD_STR Character(5) VARCHAR2(5) NOT NULL Status Code
9 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
10 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
12 BAM_DATE Character(10) VARCHAR2(10) NOT NULL This is a Date field, to be used in BAM.
13 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
14 TOTAL_PRICE Signed Number(30,4) DECIMAL(28,4) NOT NULL Total Price
15 TOTAL_COUNT Number(7,0) INTEGER NOT NULL Total Count
16 QUOTE_CONV_ORDER Number(7,0) INTEGER NOT NULL Number of Quotes Converted Orders