PRCR_DS_RFQ_VW

(SQL View)
Index Back

Approved RFQ View


SELECT H.BUSINESS_UNIT , H.RFQ_ID , H.RFQ_STATUS , H.RFQ_REF , H.BUYER_ID , H.REQUEST_DATE , H.ADVERTISED_DT , H.OPRID_ENTERED_BY , H.ENTERED_DT , H.BILL_LOCATION , L.CURRENCY_CD , %Round(SUM(%DecMult(L.QTY_RFQ, L.PRICE_RFQ)), 2) FROM PS_RFQ_HDR H , PS_RFQ_LINE L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.RFQ_ID = L.RFQ_ID GROUP BY H.BUSINESS_UNIT , H.RFQ_ID , H.RFQ_STATUS , H.RFQ_REF , H.BUYER_ID , H.REQUEST_DATE , H.ADVERTISED_DT , H.OPRID_ENTERED_BY , H.ENTERED_DT , H.BILL_LOCATION , L.CURRENCY_CD

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

2 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
3 RFQ_STATUS Character(1) VARCHAR2(1) NOT NULL RFQ Status
A=Approved
C=Closed
H=On Hold
O=Open
X=Canceled

Default Value: OPR_DEF_TBL_PM.RFQ_STATUS

4 RFQ_REF Character(30) VARCHAR2(30) NOT NULL RFQ Reference
5 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW

6 REQUEST_DATE Date(10) DATE Requested

Default Value: %date

7 ADVERTISED_DT Date(10) DATE RFQ Advertised Date
8 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
9 ENTERED_DT Date(10) DATE Entered on
10 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location

Default Value: BUS_UNIT_TBL_PM.BILL_LOCATION

Prompt Table: LOCATION_TBL

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label