OM_SHIP_CNT_LVW

(SQL View)
 Index Back

OM Shipping Container view

Related language view of OM_SHIP_CNTR_VW

SELECT H.BUSINESS_UNIT , H.SHIP_CNTR_ID , L.LANGUAGE_CD , H.DESCR , H.DESCRLONG FROM PS_SHIP_CNTR_HDR H , PS_SHIP_CNTR_INV I , PS_IN_DEMAND D , PS_SHIP_CNTR_LNG L WHERE %Join(COMMON_KEYS, SHIP_CNTR_HDR H, SHIP_CNTR_INV I) AND D.BUSINESS_UNIT = I.BUSINESS_UNIT AND D.DEMAND_SOURCE = I.DEMAND_SOURCE AND D.SOURCE_BUS_UNIT = I.SOURCE_BUS_UNIT AND D.ORDER_NO = I.ORDER_NO AND D.ORDER_INT_LINE_NO = I.ORDER_INT_LINE_NO AND D.SCHED_LINE_NBR = I.SCHED_LINE_NBR AND D.INV_ITEM_ID = I.INV_ITEM_ID AND D.DEMAND_LINE_NO = I.DEMAND_LINE_NO AND %Join(COMMON_KEYS, SHIP_CNTR_HDR H, SHIP_CNTR_LNG L)

  • Related Language Record for OM_SHIP_CNT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRLONG Long Character CLOB Long Description