PL_BOM_HEADR_VW (SQL View)	Index Back
Planning BOM Header View Used to only select and maintain BOMs that are Enterprise (EP) BOMs. It is a clone of the EN - Engineering view for the similiar set of panels. SCC 07/01/97 CN# PL700-DI-SCHEW-11: Changed business_unit prompt table. 06/08/00 RT created rl view PL_BOM_HEADRLVW 2/16/98 RS : RL View Type OTH C2 CN# EN800-3.0, Sep 21 98, Anna Added field BomCode Set the BomCode to 1 in the defn, this may need to be corrected later ??

PL_BOM_HEADR_VW

(SQL View)

Planning BOM Header View

Used to only select and maintain BOMs that are Enterprise (EP) BOMs. It is a clone of the EN - Engineering view for the similiar set of panels. SCC 07/01/97 CN# PL700-DI-SCHEW-11: Changed business_unit prompt table. 06/08/00 RT created rl view PL_BOM_HEADRLVW 2/16/98 RS : RL View Type OTH C2 CN# EN800-3.0, Sep 21 98, Anna Added field BomCode Set the BomCode to 1 in the defn, this may need to be corrected later ??

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , B.DESCR FROM PS_PL_BOM_HEADER A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND B.SETID = C.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID

Related Language Record: PL_BOM_HEADRLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: ITM_NON_INV_VW

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description