PRCR_LGD_PO_VW(SQL View) |
Index Back |
---|---|
Procurement Line Grp Dtl PO VWProcurement 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 |