BUSINESS_UNITREQ_IDREQ_LINE_NBRREQ_SCHED_NBRPrompt Table: %EDITTABLE5
01=Standard
02=Stockless
BO=Bill Only
BR=Bill and Replace
STD=Standard
REQ_PO_LN_VW2(SQL View) |
Index Back |
|---|---|
Selector Order By Item Descr02/12/2007 SSN 699423 - Performance Issue Created View |
| SELECT DISTINCT L.BUSINESS_UNIT , L.REQ_ID , L.LINE_NBR , S.SCHED_NBR , L.ITM_SETID , L.INV_ITEM_ID , L.VENDOR_SETID , L.VENDOR_ID , L.BUYER_ID , L.CATEGORY_ID , H.ORIGIN , H.REQ_NAME , L.INVENTORY_SRC_FLG , L.REPLEN_OPT , H.REQ_TYPE FROM PS_REQ_LINE L , PS_REQ_HDR H , PS_REQ_LINE_SHIP S , PS_REQ_LN_DISTRIB SO WHERE L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.BUSINESS_UNIT = SO.BUSINESS_UNIT AND L.REQ_ID = H.REQ_ID AND L.REQ_ID = S.REQ_ID AND L.REQ_ID = SO.REQ_ID AND L.LINE_NBR = S.LINE_NBR AND L.LINE_NBR = SO.LINE_NBR AND S.SCHED_NBR = SO.SCHED_NBR AND H.IN_PROCESS_FLG = 'N' AND H.HOLD_STATUS = 'N' AND H.BUDGET_HDR_STATUS = 'V' AND L.CURR_STATUS = 'A' AND L.RFQ_IND = 'N' AND L.IN_PROCESS_FLG = 'N' AND L.SOURCE_STATUS = 'A' AND L.SOURCE_DATE <= %CurrentDateIn AND S.BAL_STATUS = 'I' AND SO.KK_CLOSE_FLAG <> 'Y' AND (SO.QTY_OPEN > 0 OR SO.AMT_OPEN <> 0) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 3 | REQ_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 4 | REQ_SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
| 5 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: %EDITTABLE5 |
| 9 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 10 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 11 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
| 12 | REQ_NAME | Character(30) | VARCHAR2(30) NOT NULL | Requisition Name |
| 13 | INVENTORY_SRC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Inventory Source Flag |
| 14 | REPLEN_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Replenish Code
01=Standard 02=Stockless |
| 15 | REQ_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Requisition Type
BO=Bill Only BR=Bill and Replace STD=Standard |