DMND_CARRIER_VW (SQL View)	Index Back
Pick FdBk Carrier Prompt View 04/27/04 MEG CN#IN890 Data Model Changes - Replaced demand_inv with in_demand and cancel_flag with in_fulfill_state.

DMND_CARRIER_VW

(SQL View)

Pick FdBk Carrier Prompt View

04/27/04 MEG CN#IN890 Data Model Changes - Replaced demand_inv with in_demand and cancel_flag with in_fulfill_state.

SELECT DISTINCT business_unit , carrier_id FROM PS_IN_DEMAND WHERE in_fulfill_state IN ('30','40') AND fulfill_flag = 'Y' AND carrier_id <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUIN_NONVW

2 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID