DP_DDHUPD_CP_VW

(SQL View)
 Index Back

Extract configured components

Select messaging data from OM (order) tables for configured components only

SELECT PS_DP_DDH_CFGCP_VW.BUSINESS_UNIT , PS_DP_DDH_CFGCP_VW.PRIORITY_SHIP_FROM , PS_DP_DDH_CFGCP_VW.ORDER_NO , PS_DP_DDH_CFGCP_VW.CURRENCY_CD , PS_DP_DDH_CFGCP_VW.SHIP_TO_CUST_ID , PS_DP_DDH_CFGCP_VW.QTY_REQUESTED , PS_DP_DDH_CFGCP_VW.QTY_REQUESTED_BASE , PS_DP_DDH_CFGCP_VW.QTY_BACKORDER , PS_DP_DDH_CFGCP_VW.QTY_BACKORDER_BASE , PS_DP_DDH_CFGCP_VW.ORDER_INT_LINE_NO , PS_DP_DDH_CFGCP_VW.SCHED_LINE_NBR , PS_DP_DDH_CFGCP_VW.DEMAND_LINE_NO , PS_DP_DDH_CFGCP_VW.UNIT_MEASURE_SHIP , PS_DP_DDH_CFGCP_VW.UNIT_OF_MEASURE , PS_DP_DDH_CFGCP_VW.NET_UNIT_PRICE , PS_DP_DDH_CFGCP_VW.PRODUCT_ID , PS_DP_DDH_CFGCP_VW.COMPONENT_ID , PS_DP_DDH_CFGCP_VW.SF_QTY_PER , PS_DP_DDH_CFGCP_VW.UNIT_MEASURE_STD , PS_DP_DDH_CFGCP_VW.REQUEST_DATE , PS_DP_DDH_CFGCP_VW.CURRENCY_CD_BASE , PS_DP_DDH_CFGCP_VW.CONFIG_CODE , PS_DP_DDH_CFGCP_VW.SOLD_TO_CUST_ID , PS_DP_DDH_CFGCP_VW.SOURCE_CODE , PS_DP_DDH_CFGCP_VW.BUSINESS_UNIT_BI , PS_DP_DDH_CFGCP_VW.BUSINESS_UNIT_IN , PS_DP_DDH_CFGCP_VW.SETID , PS_DP_DDH_CFGCP_VW.FORECAST_ITEM_FLAG , PS_DP_DDH_CFGCP_VW.FORECASTER , PS_DP_DDH_CFGCP_VW.INV_ITEM_ID , PS_DP_DDH_CFGCP_VW.PRODUCT_KIT_FLAG , PS_DP_DDH_CFGCP_VW.DIST_CFG_FLAG , PS_DP_DDH_CFGCP_VW.PRDN_CFG_FLAG , PS_DP_DDH_CFGCP_VW.DP_KIT_PARENT_QTY , PS_DP_DDH_CFGCP_VW.DP_KIT_PARENT_UOM , PS_DP_DDH_CFGCP_VW.DP_UPDDTTM_1 , PS_DP_DDH_CFGCP_VW.DP_UPDDTTM_0 , PS_DP_DDH_CFGCP_VW.DP_UPDDTTM_2 , PS_DP_DDH_CFGCP_VW.DATE_LAST_MAINT , PS_DP_DMDINDEX_OM.DP_DDH_ID , PS_DP_DDH_CFGCP_VW.IN_FULFILL_STATE FROM PS_DP_DDH_CFGCP_VW , PS_DP_DMDINDEX_OM WHERE PS_DP_DDH_CFGCP_VW.BUSINESS_UNIT = PS_DP_DMDINDEX_OM.BUSINESS_UNIT(+) AND PS_DP_DDH_CFGCP_VW.ORDER_NO = PS_DP_DMDINDEX_OM.ORDER_NO(+) AND PS_DP_DDH_CFGCP_VW.ORDER_INT_LINE_NO = PS_DP_DMDINDEX_OM.ORDER_INT_LINE_NO(+) AND PS_DP_DDH_CFGCP_VW.SCHED_LINE_NBR = PS_DP_DMDINDEX_OM.SCHED_LINE_NBR(+) AND PS_DP_DDH_CFGCP_VW.PRODUCT_ID = PS_DP_DMDINDEX_OM.PRODUCT_ID(+) AND PS_DP_DDH_CFGCP_VW.COMPONENT_ID = PS_DP_DMDINDEX_OM.COMPONENT_ID(+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRIORITY_SHIP_FROM Character(5) VARCHAR2(5) NOT NULL PRIORITY SHIP FROM BUSINESS UNIT
3 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
5 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
6 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
7 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
8 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
9 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
10 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
11 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
12 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
13 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
15 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
16 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
17 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
18 SF_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL 07/06/99 SCC CN# SF800-9.0: Added label Quantity
19 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
20 REQUEST_DATE Date(10) DATE Requested
21 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
22 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
23 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
24 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
25 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
26 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
27 SETID Character(5) VARCHAR2(5) NOT NULL SetID
28 FORECAST_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Demand Planning Item
29 FORECASTER Character(20) VARCHAR2(20) NOT NULL Forecaster
30 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
31 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit
32 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration
33 PRDN_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Production Configuration
34 DP_KIT_PARENT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Demand Planning Kit Parent Qty
35 DP_KIT_PARENT_UOM Character(3) VARCHAR2(3) NOT NULL DP Kit Parent Unit of Measure
36 DP_UPDDTTM_1 DateTime(26) TIMESTAMP date/time of last update to level 1 record used by messaging system to select records changed in the FDM system
37 DP_UPDDTTM_0 DateTime(26) TIMESTAMP date/time of last update to level 0 record used by messaging system to select records changed in the FDM system
38 DP_UPDDTTM_2 DateTime(26) TIMESTAMP date/time of last update to level 2 record used by messaging system to select records changed in the FDM system
39 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
40 DP_DDH_ID Character(30) VARCHAR2(30) NOT NULL Demand data history table - row ID (key)
41 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled