PV_REQ_TMPL_VW2

(SQL View)
 Index Back

Req Template View

Req Template View - with active catalogs Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

SELECT BUSINESS_UNIT , REQ_ID , LINE_NBR , IN_PROCESS_FLG , PROCESS_INSTANCE , QTY_REQ , ITM_SETID , INV_ITEM_ID , VENDOR_SETID , VENDOR_ID , ITM_ID_VNDR , VNDR_CATALOG_ID , BUYER_ID , CATEGORY_ID , UNIT_OF_MEASURE , MFG_ID , PRICE_REQ , MERCHANDISE_AMT , INSPECT_CD , SYSTEM_SOURCE , SOURCE_STATUS , SOURCE_DATE , CURRENCY_CD , PCT_UNIT_PRC_TOL , UNIT_PRC_TOL , INVENTORY_SRC_FLG , OVERRIDE_SUGG_VNDR , CONSOLIDATE_FLG , ROUTING_ID , RFQ_IND , CURRENCY_CD_BASE , UNIT_MEASURE_STD , MERCH_AMT_BSE , QTY_REQ_STD , PRICE_REQ_BSE , UNIT_PRC_TOL_BSE , DESCR254_MIXED , BUSINESS_UNIT_CP , CONFIG_CODE , CP_TEMPLATE_ID , BUSINESS_UNIT_IN , ZERO_PRICE_IND , VNDR_LOC , PRICE_SETID , PRICE_VENDOR , PRICE_LOC , MFG_ITM_ID , CALC_PRICE_FLG , REPLEN_OPT , GPO_ID , GPO_CNTRCT_NBR , CURR_STATUS , PHYSICAL_NATURE FROM PS_REQ_LINE REQ WHERE (EXISTS( SELECT 'X' FROM PS_MASTER_ITEM_TBL A , PS_PURCH_ITEM_ATTR F , PS_PV_CAT_TREE_TBL T WHERE A.SETID = F.SETID AND A.INV_ITEM_ID = F.INV_ITEM_ID AND REQ.ITM_SETID = A.SETID AND REQ.INV_ITEM_ID = A.INV_ITEM_ID AND A.SETID = T.SETID AND A.CATEGORY_ID = T.CATEGORY_ID AND ((%CurrentDateIn >= F.PO_AVAIL_DT) AND (F.PO_UNAVAIL_DT > %CurrentDateIn )) AND( (A.ITM_STATUS_CURRENT = '1' AND A.ITM_STATUS_FUTURE=' ') OR ((A.ITM_STATUS_FUTURE ='1' AND A.ITM_STAT_DT_FUTURE <=%CurrentDateIn) OR (A.ITM_STATUS_FUTURE <>'1' AND A.ITM_STAT_DT_FUTURE >%CurrentDateIn AND A.ITM_STATUS_CURRENT = '1')) )) AND (VENDOR_ID = ' ' OR EXISTS ( SELECT 'X' FROM PS_ITM_VENDOR IV , PS_VENDOR V WHERE IV.VENDOR_SETID = V.SETID AND IV.VENDOR_ID = V.VENDOR_ID AND IV.VENDOR_SETID = REQ.VENDOR_SETID AND IV.VENDOR_ID = REQ.VENDOR_ID AND IV.SETID = REQ.ITM_SETID AND IV.INV_ITEM_ID = REQ.INV_ITEM_ID AND IV.ITM_STATUS = 'A' AND V.VENDOR_STATUS = 'A' AND V.VNDR_STATUS_PO = 'Y') OR NOT EXISTS ( SELECT 'X' FROM PS_ITM_VENDOR IV , PS_VENDOR V WHERE IV.VENDOR_SETID = V.SETID AND IV.VENDOR_ID = V.VENDOR_ID AND IV.VENDOR_SETID = REQ.VENDOR_SETID AND IV.VENDOR_ID = REQ.VENDOR_ID AND IV.SETID = REQ.ITM_SETID AND IV.INV_ITEM_ID = REQ.INV_ITEM_ID)) OR (REQ.INV_ITEM_ID = ' ' AND (VENDOR_ID = ' ' OR EXISTS( SELECT 'X' FROM PS_VENDOR V1 WHERE V1.SETID=REQ.VENDOR_SETID AND V1.VENDOR_ID= REQ.VENDOR_ID AND V1.VENDOR_STATUS = 'A' AND V1.VNDR_STATUS_PO = 'Y'))))

  • Related Language Record: PV_REQLINEVW_RL

    • # 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

    Default Value: NEXT

    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    4 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Y/N Table Edit

    Default Value: N

    5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    6 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
    7 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: ITM_PURCH_VW

    9 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: %EDITTABLE5

    11 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    12 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
    13 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: BUYER_TBL

    14 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

    Prompt Table: ITM_CAT_TBL

    15 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: %EDIT_UOM

    16 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    17 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
    18 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    19 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    20 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

    Default Value: PPO

    21 SOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL AutoSource Status
    A=Available
    C=Sourcing Complete
    E=Non-Price Error
    I=Sourcing In Process
    N=Non-Price Error
    P=Pricing Error

    Default Value: N

    22 SOURCE_DATE Date(10) DATE NOT NULL Source Date

    Default Value: %DATE

    23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: REQ_HDR.CURRENCY_CD

    24 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
    25 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
    26 INVENTORY_SRC_FLG Character(1) VARCHAR2(1) NOT NULL Inventory Source Flag

    Y/N Table Edit

    Default Value: N

    27 OVERRIDE_SUGG_VNDR Character(1) VARCHAR2(1) NOT NULL Override Suggested Vendor

    Y/N Table Edit

    Default Value: Y

    28 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    29 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID

    Prompt Table: ROUTING_HDR

    30 RFQ_IND Character(1) VARCHAR2(1) NOT NULL RFQ Required
    N=No
    Y=Yes

    Default Value: N

    31 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

    Default Value: REQ_HDR.CURRENCY_CD_BASE

    32 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    33 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
    34 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
    35 PRICE_REQ_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
    36 UNIT_PRC_TOL_BSE Number(14,5) DECIMAL(13,5) NOT NULL Base Unit Price Tolerance
    37 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    38 BUSINESS_UNIT_CP Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: %EDIT_BU_IN
    Set Control Field: BUSINESS_UNIT_IN

    39 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

    Prompt Table: CP_CONFIG_PO_VW
    Set Control Field: BUSINESS_UNIT_CP

    40 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
    41 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: %EDIT_BU_IN

    42 ZERO_PRICE_IND Character(1) VARCHAR2(1) NOT NULL Zero Price Indicator

    Y/N Table Edit

    Default Value: N

    43 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: VNDR_LOC_REQ_VW

    44 PRICE_SETID Character(5) VARCHAR2(5) NOT NULL Price From Vendor SetID
    45 PRICE_VENDOR Character(10) VARCHAR2(10) NOT NULL Price Vendor ID
    46 PRICE_LOC Character(10) VARCHAR2(10) NOT NULL Price from Location
    47 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

    Prompt Table: ITEM_MFG_ID_VW

    48 CALC_PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Calculate Price?
    49 REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Replenish Code
    01=Standard
    02=Stockless
    50 GPO_ID Character(18) VARCHAR2(18) NOT NULL GPO ID
    51 GPO_CNTRCT_NBR Character(25) VARCHAR2(25) NOT NULL GPO Contract Number
    52 CURR_STATUS Character(1) VARCHAR2(1) NOT NULL Current Status
    A=Approved
    C=Closed
    D=Denied
    H=Hold
    O=Open
    P=Pending
    X=Canceled

    Default Value: A

    53 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services