SHIP_CNFMD_VW (SQL View)	Index Back
Picked, confirmed, by load id 04/05/04 MEG CN#IN890: Modified view to select from IN_DEMAND instead of SHIP_INF_INV. Added in_fulfill_status and removed cancel_flag from the viewtext.

SHIP_CNFMD_VW

(SQL View)

Picked, confirmed, by load id

04/05/04 MEG CN#IN890: Modified view to select from IN_DEMAND instead of SHIP_INF_INV. Added in_fulfill_status and removed cancel_flag from the viewtext.

SELECT DISTINCT business_unit , load_id FROM PS_IN_DEMAND WHERE pick_batch_id > 0 AND in_fulfill_state IN ('50','60','70') AND fulfill_flag = 'Y' AND confirmed_flag = 'Y' AND load_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 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID