PL_OMFCSTADD_VW

(SQL View)
Index Back

Product Inventory Item View

Product Inventory Item View

SELECT BUSINESS_UNIT_IN , BUSINESS_UNIT_OM , PRODUCT_ID FROM PS_PL_OM_FCST_PCT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SP_BUIN_NONVW

2 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

Prompt Table: SP_BU_OM_NONVW

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PL_PROD_ITEM_VW