PL_CNCL_BA_LVW

(SQL View)
 Index Back

Cancelled Buying Agreements

04/11/03 JC (ICE582988000): Added

SELECT A.PROBINST , A.BUSINESS_UNIT , A.INV_ITEM_ID , B.CFG_CODE_OPT , A.CONFIG_CODE , A.REMAINING_QTY , B.UNIT_MEASURE_STD , 0 , 0 , ' ' , A.ORDER_NO , A.SETID , A.CNTRCT_ID , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.KIT_LINE_NBR , C.LANGUAGE_CD , A.SHIP_TO_CUST_ID , A.SHIP_FROM_BU , A.PRODUCT_ID , A.SETID_CUSTOMER , C.NAME1 , C.NAMESHORT FROM PS_PL_ORD_SCHEBAVW A , PS_PL_BU_ITEMS B , PS_CUSTOMER_LANG C WHERE A.PROBINST = B.PROBINST AND A.SHIP_FROM_BU = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.INCL_QTY_FLG = 'Y' AND A.ORD_SCH_STATUS = 'X' AND C.SETID = A.SETID_CUSTOMER AND C.CUST_ID = A.SHIP_TO_CUST_ID

  • Related Language Record for PL_CNCL_BA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDITTABLE2

    4 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
    B=Both
    N=No
    Y=Yes
    5 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    6 REMAINING_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 JNW (CN#PL900-1.0): Added
    7 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    8 RESCHED_DAYS_IN Number(5,0) INTEGER NOT NULL 10/22/02 JC (CN#PL880-1):Added
    9 RESCHED_DAYS_OUT Number(5,0) INTEGER NOT NULL 10/22/02 JC (CN#PL880-1):Added
    10 DETAIL_BTN Character(1) VARCHAR2(1) NOT NULL Details
    11 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    12 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    13 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    14 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    15 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    16 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
    17 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    18 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    19 PL_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    20 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    21 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
    22 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    23 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name