GST_ORDER_VW

(SQL View)
 Index Back

View for advance payment

View for orders for advance payment

SELECT DISTINCT H.ORDER_NO , H.BUSINESS_UNIT , H.SOLD_TO_CUST_ID , S.NAME1 , V.LIST_PRICE + V.PRICE + V1.LIST_PRICE + V2.LIST_PRICE , H.CURRENCY_CD_BASE FROM PS_ORD_HEADER H , PS_ORD_LINE L , PS_CUSTOMER S , PS_GST_ORDER_VW1 V , PS_GST_ORDER_VW2 V1 , PS_GST_ORDER_VW3 V2 , PS_SET_CNTRL_REC D WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.BUSINESS_UNIT = V.BUSINESS_UNIT AND H.BUSINESS_UNIT = V1.BUSINESS_UNIT AND L.BUSINESS_UNIT = V.BUSINESS_UNIT AND L.BUSINESS_UNIT = V1.BUSINESS_UNIT AND V.BUSINESS_UNIT = V1.BUSINESS_UNIT AND H.BUSINESS_UNIT = V2.BUSINESS_UNIT AND V.BUSINESS_UNIT = V2.BUSINESS_UNIT AND V1.BUSINESS_UNIT = V2.BUSINESS_UNIT AND L.BUSINESS_UNIT = V2.BUSINESS_UNIT AND H.ORDER_NO = L.ORDER_NO AND L.ORDER_NO = V.ORDER_NO AND L.ORDER_NO = V1.ORDER_NO AND H.ORDER_NO = V.ORDER_NO AND H.ORDER_NO = V1.ORDER_NO AND V.ORDER_NO = V1.ORDER_NO AND H.ORDER_NO = V2.ORDER_NO AND L.ORDER_NO = V2.ORDER_NO AND V.ORDER_NO = V2.ORDER_NO AND V1.ORDER_NO = V2.ORDER_NO AND H.SOLD_TO_CUST_ID = S.CUST_ID AND H.BUSINESS_UNIT = D.SETCNTRLVALUE AND S.SETID = D.SETID AND D.RECNAME = 'CUSTOMER' AND H.BUSINESS_UNIT = ( SELECT DISTINCT P.BUSINESS_UNIT FROM PS_ORG_BU_TAX_APPL P WHERE P.ORG_BU_TYPE IN ('OM','AR') AND P.STX_OTC_APPL = 'Y' AND P.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.BUSINESS_UNIT = P.BUSINESS_UNIT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
5 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code