SP_BUINSR_CLSVW

(SQL View)
Index Back

Sec Vw - Stock Requests


SELECT DISTINCT b.oprclass , a.business_unit , a.demand_source , a.source_bus_unit FROM ps_issue_hdr_inv a , PS_SEC_BU_CLS b WHERE a.source_bus_unit = b.business_unit

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