PRCR_LGD_PO_VW

(SQL View)
Index Back

Procurement Line Grp Dtl PO VW

Procurement Line Group Detail Spending PO view.

SELECT DISTINCT PL.BUSINESS_UNIT , PL.PO_ID , 'PO' , S.BUSINESS_UNIT , S.AUC_ID , S.AUC_ROUND , S.AUC_VERSION , S.LINE_NBR , PL.AUC_GROUP_ID , PL.INV_ITEM_ID , PL.DESCR254_MIXED , SUM(S.AUC_AWARD_QTY) , AL.UNIT_OF_MEASURE , SUM(PS.QTY_PO) , SUM(PS.MERCHANDISE_AMT) , SUM(S.MERCHANDISE_AMT) , PS.CURRENCY_CD , %Abs(SUM(S.AUC_AWARD_QTY) - SUM(PS.QTY_PO)) , %Abs(SUM(S.MERCHANDISE_AMT) - SUM(PS.MERCHANDISE_AMT)) FROM PS_PO_LINE PL , PS_PO_LINE_SHIP PS , PS_AUC_AWARD_DSTRB AD , PS_AUC_AWARD_SHIP S , PS_AUC_LINE AL WHERE PL.BUSINESS_UNIT = AD.BUSINESS_UNIT_PO AND PL.PO_ID = AD.PO_ID AND PL.LINE_NBR = AD.PO_LINE_NBR AND PL.AUC_GROUP_ID <> ' ' AND PL.AUC_GROUP_ID = S.AUC_GROUP_ID AND PS.BUSINESS_UNIT = AD.BUSINESS_UNIT_PO AND PS.PO_ID = AD.PO_ID AND PS.LINE_NBR = AD.PO_LINE_NBR AND PS.SCHED_NBR = AD.PO_SCHED_NBR AND AD.BUSINESS_UNIT = S.BUSINESS_UNIT AND AD.AUC_ID = S.AUC_ID AND AD.AUC_ROUND = S.AUC_ROUND AND AD.AUC_VERSION = S.AUC_VERSION AND AD.LINE_NBR = S.LINE_NBR AND AD.SCHED_NBR = S.SCHED_NBR AND AD.BIDNUM = S.BIDNUM AND AD.BIDDER_SETID = S.BIDDER_SETID AND AD.BIDDER_ID = S.BIDDER_ID AND AD.BIDDER_TYPE = S.BIDDER_TYPE AND AD.BIDDER_LOC = S.BIDDER_LOC AND AD.AUC_AWARD_NBR = S.AUC_AWARD_NBR AND S.AUC_GROUP_ID <> ' ' AND AD.BUSINESS_UNIT = AL.BUSINESS_UNIT AND AD.AUC_ID = AL.AUC_ID AND AD.AUC_ROUND = AL.AUC_ROUND AND AD.AUC_VERSION = AL.AUC_VERSION AND AD.LINE_NBR = AL.LINE_NBR GROUP BY PL.BUSINESS_UNIT , PL.PO_ID , S.BUSINESS_UNIT , S.AUC_ID , S.AUC_ROUND , S.AUC_VERSION , S.LINE_NBR , PL.AUC_GROUP_ID , PL.INV_ITEM_ID , PL.DESCR254_MIXED , AL.UNIT_OF_MEASURE , PS.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PRCR_DOC_ID Character(25) VARCHAR2(25) NOT NULL Go to this doc's inquiry page
3 PRCR_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL Document Type
CNT=Contract
IUR=Inter Unit Receipt
MSR=MSR
PMT=Payment
PO=Purchase Order
RCV=Receipt
REQ=Requisition
RFQ=Request For Quote
RTV=Return To Vendor (Supplier)
SSE=Strategic Sourcing Event
VOU=Voucher
WO=Work Order
4 BUSINESS_UNIT_SS Character(5) VARCHAR2(5) NOT NULL Strategic Sourcing BU
5 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
6 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
7 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
8 AUC_LINE_NBR Number(5,0) INTEGER NOT NULL Strategic Sourcing Line Number
9 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 AUC_AWARD_QTY Number(16,4) DECIMAL(15,4) NOT NULL Total Awarded Qty
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
14 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
15 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
16 AWARDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Government Contract Awarded Amount
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: PRCR_LGD_INQ_WS.CURRENCY_CD

18 QTY_REMAIN Signed Number(17,4) DECIMAL(15,4) NOT NULL Remaining Quantity
19 AMT_REMAINING Signed Number(28,3) DECIMAL(26,3) NOT NULL Remaining Amount