CNTR_ID_PRT2_VW

(SQL View)
Index Back

INV Container ID Prompt Vw


SELECT DISTINCT A.BUSINESS_UNIT, A.CONTAINER_ID, A.DESCR FROM PS_CNTR_ID_INV A WHERE EXISTS (SELECT 'X' FROM PS_PHYSICAL_INV B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.CONTAINER_ID = A.CONTAINER_ID AND (B.QTY - B.QTY_RESERVED > 0)) AND NOT EXISTS (SELECT 'X' FROM PS_PHYSICAL_INV G WHERE G.BUSINESS_UNIT = A.BUSINESS_UNIT AND G.CONTAINER_ID = A.CONTAINER_ID AND (G.AVAIL_STATUS = '3' OR G.AVAIL_STATUS = '4'))

# 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 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

Default Value: NEXT

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description