RO_ORD_LNRGB_VW

(SQL View)
 Index Back

Order Metrics Line for BU

Order Metrics Order Line with Region information for single Business Unit.

SELECT DISTINCT A.PROBINST , A.CAPTURE_ID , A.LINE_NBR , A.CAPTURE_TYPE_CD , A.RO_MONTHS , A.BUSINESS_UNIT , A.SOURCE_CD , A.CURRENCY_CD , A.STATUS_CD_STR , B.REGION_ID , A.SETID_STATUS , A.SETID_SOURCE , A.SETID_CAPTURE_TYPE , A.LIST_PRICE , A.PRICE , A.QTY_ORDERED , A.PARENT_LINE_NBR FROM PS_RO_ORD_MBULN_VW A , PS_RO_SOLD2RGNB_VW B WHERE A.PROBINST = B.PROBINST(+) AND A.CAPTURE_ID=B.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 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
4 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order
5 RO_MONTHS Character(10) VARCHAR2(10) NOT NULL View on Months Calendar for ACE Order Metrics Reports
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
9 STATUS_CD_STR Character(5) VARCHAR2(5) NOT NULL Status Code
10 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.
11 SETID_STATUS Character(5) VARCHAR2(5) NOT NULL MOC SETID Field
12 SETID_SOURCE Character(5) VARCHAR2(5) NOT NULL MOC SETID Field
13 SETID_CAPTURE_TYPE Character(5) VARCHAR2(5) NOT NULL MOC SETID Field
14 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
15 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.
16 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
17 PARENT_LINE_NBR Number(5,0) INTEGER NOT NULL Parent Line #