ITEM_DSP3_VW

(SQL View)
 Index Back

Items By SetId and BU


SELECT C.setid , I.business_unit , I.cust_id , I.item , I.item_line , C.nameshort FROM PS_ITEM I , ps_customer C WHERE c.setid IN ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = I.business_unit AND RECNAME = 'CUSTOMER') AND C.cust_id = I.cust_id AND I.ITEM_STATUS = 'O' AND I.ENTRY_TYPE NOT IN ('PPF', 'PPI') AND NOT EXISTS( SELECT 'X' FROM PS_SEL_ITEM_PLAN P WHERE P.SETID = C.SETID AND I.BUSINESS_UNIT = P.BUSINESS_UNIT AND I.CUST_ID = P.CUST_ID AND I.ITEM = P.ITEM AND I.ITEM_LINE = P.ITEM_LINE AND P.SEL = 'Y' AND (P.PAYMENT_PLAN <> ' ' OR P.PAYMENT_PLAN = ' '))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BU_EDIT_VW_AR

3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: CUST_SRCH_VW
Set Control Field: BUSINESS_UNIT

4 INSTALLMENT_ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an installment item
5 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
6 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name