IN_PROUT_TYP_VW

(SQL View)
Index Back

IN Peggable Supply View

07/26/04 EGS: Created

SELECT DISTINCT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.MG_OUTPUT_TYPE , C.XLATSHORTNAME FROM PS_SF_OUTPUT_LIST A , PS_SF_PRDNID_HEADR B , PSXLATITEM C WHERE B.PROD_STATUS < '40' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND A.MG_OUTPUT_TYPE <> 'WB' AND A.CONFIG_CODE = ' ' AND B.MA_PRDN_ID_FLG = 'Y' AND C.FIELDNAME = 'MG_OUTPUT_TYPE' AND C.EFF_STATUS = 'A' AND C.FIELDVALUE = A.MG_OUTPUT_TYPE AND %EffdtCheck(PSXLATITEM XX, C, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
3 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name