PL_OMFCSTADD_VW(SQL View) |
Index Back |
---|---|
Product Inventory Item ViewProduct 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 |