BUSINESS_UNIT_INPrompt Table: SP_BUIN_NONVW
BUSINESS_UNIT_OMPrompt Table: SP_BU_OM_NONVW
PRODUCT_IDPrompt Table: PROD_ITEM_VW
Prompt Table: SP_SETID_NONVW
Prompt Table: MASTER_ITEM_TBL
PROD_ITEM_VW2(SQL View) |
Index Back |
|---|---|
Product Inventory Item ViewProduct Inventory Item View |
| SELECT BII.BUSINESS_UNIT , %Substring(SCR.SETCNTRLVALUE , 1 , 5) , PI.PRODUCT_ID , PI.SETID , PI.INV_ITEM_ID FROM PS_PROD_ITEM PI , PS_BU_ITEMS_INV BII , PS_SET_CNTRL_REC SCR WHERE PI.INV_ITEM_ID = BII.INV_ITEM_ID AND SCR.RECNAME = 'PROD_ITEM' AND PI.SETID = SCR.SETID |
| # | 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: PROD_ITEM_VW |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MASTER_ITEM_TBL |