BOL_ORDERN2_VW

(SQL View)
 Index Back

BOL -Shipped OM Orders

View is used when construction the Shipping Bill of Lading.

SELECT DISTINCT business_unit , source_bus_unit , order_no FROM PS_IN_DEMAND WHERE in_fulfill_state BETWEEN '20' AND '70' AND bill_of_lading = ' ' AND ship_id <> ' ' AND ((EXPORT = 'Y' AND DEMAND_SOURCE <> 'OM') OR ORDER_NO IN ( SELECT DISTINCT S.ORDER_NO FROM PS_IN_DEMAND S , PS_ORD_LINE L , PS_ORD_SCHEDULE C WHERE S.DEMAND_SOURCE = 'OM' AND S.IN_FULFILL_STATE BETWEEN '20' AND '70' AND S.SOURCE_BUS_UNIT = L.BUSINESS_UNIT AND S.ORDER_NO = L.ORDER_NO AND S.SOURCE_BUS_UNIT = C.BUSINESS_UNIT AND S.ORDER_NO = C.ORDER_NO AND S.SHIP_TO_CUST_ID <> ' ' AND (L.EXPORT = 'Y' OR C.EXPORT = 'Y')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
3 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