DP_DDH_ITEMM_VW

(SQL View)
Index Back

Fetch Item data for DDH

view to fetch basic INV ITEM data for transfer to demand history. Custom Item field are comming form MATER_ITEM_TBL.

SELECT IM.SETID , IB.BUSINESS_UNIT , IM.INV_ITEM_ID , IM.INV_ITEM_GROUP , IM.DESCR , IM.CATEGORY_ID , IM.INV_PROD_FAM_CD , II.INV_ITEM_TYPE , II.INV_ITEM_COLOR , II.UPC_ID , IM.ITEM_FIELD_C10_A , IM.ITEM_FIELD_C10_B , IM.ITEM_FIELD_C10_C , IM.ITEM_FIELD_C10_D , IM.ITEM_FIELD_C1_A , IM.ITEM_FIELD_C1_B , IM.ITEM_FIELD_C1_C , IM.ITEM_FIELD_C1_D , IM.ITEM_FIELD_C2 , IM.ITEM_FIELD_C30_A , IM.ITEM_FIELD_C30_B , IM.ITEM_FIELD_C30_C , IM.ITEM_FIELD_C30_D , IM.ITEM_FIELD_C4 , IM.ITEM_FIELD_C6 , IM.ITEM_FIELD_C8 , IM.ITEM_FIELD_N12_A , IM.ITEM_FIELD_N12_B , IM.ITEM_FIELD_N12_C , IM.ITEM_FIELD_N12_D , IM.ITEM_FIELD_N15_A , IM.ITEM_FIELD_N15_B , IM.ITEM_FIELD_N15_C , IM.ITEM_FIELD_N15_D , IB.FORECAST_ITEM_FLAG , ' ' , ' ' FROM PS_MASTER_ITEM_TBL IM , PS_INV_ITEMS II , PS_BU_ITEMS_INV IB WHERE IB.INV_ITEM_ID = IM.INV_ITEM_ID AND (II.SETID = IM.SETID AND II.INV_ITEM_ID = IM.INV_ITEM_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
5 MITBL_DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
7 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
8 INV_ITEM_TYPE Character(5) VARCHAR2(5) NOT NULL Item Type
9 INV_ITEM_COLOR Character(10) VARCHAR2(10) NOT NULL Item Color
10 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
11 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
12 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
13 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
14 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
15 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
16 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
17 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
18 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
19 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
20 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
21 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
22 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
23 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
24 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
25 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
26 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
27 ITEM_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
28 ITEM_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
29 ITEM_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
30 ITEM_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL User-defined item field - Unsigned Decimal 12.3
31 ITEM_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
32 ITEM_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
33 ITEM_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
34 ITEM_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User-defined item field - Unsigned Decimal 15.0
35 FORECAST_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Demand Planning Item
36 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type

Prompt Table: DP_UTILIZ_CD_VW

37 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count

Prompt Table: DP_UTILIZ_GP_VW