SHIP_CNFMP_VW

(SQL View)
Index Back

Picked, confirmed, pick batch

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 , pick_batch_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'

# 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 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID