ORDENT_LOTALLVW

(SQL View)
 Index Back

Lot Allocation Table View

Related language rec for ORDENT_LOTAL_VW Date Init. Issue # Description 051304 dms F-KNANN-V59N4 Replace sched_line_no

SELECT a.business_unit , a.demand_source , a.source_bus_unit , a.order_no , a.order_int_line_no , a.sched_line_nbr , b.language_cd , b.descr FROM PS_LOT_ALLOC_INV a , ps_LOT_CNTL_IN_LNG b WHERE a.business_unit = b.business_unit AND a.inv_item_id = b.inv_item_id AND a.inv_lot_id = b.inv_lot_id

  • Related Language Record for ORDENT_LOTAL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
    IN=Material Request
    OM=Sales Order
    PL=Planning Requisition
    PO=Purchase Order
    PR=Purchasing Requisition
    RT=Material Return
    SF=Production Request
    WM=Work Order
    3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
    4 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
    5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description