RO_ORD_REVNB_VW(SQL View) |
Index Back |
---|---|
Enterprise Order RevenueInput 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 |