C360_ITM_DS1_VW (SQL View)	Index Back
Items By SetId and BU

C360_ITM_DS1_VW

(SQL View)

Items By SetId and BU

SELECT DISTINCT I.business_unit , I.item 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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BU_EDIT_VW_AR

2 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BU_EDIT_VW_AR
2	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.