RF_IPPM_SRH_VW2 (SQL View)	Index Back
Installed Product Installed Product View for searching Preventive Maintenance Service Orders on the Review Preventive Maintenance Configurable Search component.

RF_IPPM_SRH_VW2

(SQL View)

Installed Product

Installed Product View for searching Preventive Maintenance Service Orders on the Review Preventive Maintenance Configurable Search component.

SELECT B.SETID , B.INST_PROD_ID , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , D.BO_NAME_DISPLAY , D.BO_NAME_AC , A.PRODUCT_ID , A.SERIAL_ID , A.ASSETTAG , A.SITE_ID , G.BO_NAME , B.AGREEMENT_CODE , B.SERVICE_ID , B.INSPRD_PMSO_STATUS , B.SO_DATE , B.SEQ_NUM , E.DESCR , B.SO_ID , A.INV_ITEM_ID , A.ORDER_DATE , A.SHIP_DATE , A.INSTALLED_DATE , A.DEPTID , A.EXTERNAL_ID , A.LINE_NBR , A.BUSINESS_UNIT_OM , A.CAPTURE_ID , A.PARENT_INST_PRODID , B.AGR_RENEWAL_NUM , B.AGREEMENT_LINE , B.BUSINESS_UNIT , B.CREATE_DATE , B.COMMENTS254 FROM PS_RF_INST_PROD A , PS_BO_NAME D ,PS_RF_SITE_P_NM_VW G , PS_RF_INST_PROD_PM B , PS_PROD_ITEM E WHERE A.BO_ID_CUST = D.BO_ID(+) AND A.SETID = G.SETCNTRLVALUE(+) AND A.SITE_ID = G.SITE_ID(+) AND A.SETID=B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND E.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = A.SETID AND F.RECNAME = 'PROD_ITEM') AND E.PRODUCT_ID = A.PRODUCT_ID AND D.PRIMARY_IND = 'Y'

Related Language Record: RF_IP_PM_SRLVW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

6 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: RF_PROD_PMPT_VW

8 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

9 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag

10 SITE_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.

11 BO_NAME_3 Character(50) VARCHAR2(50) NOT NULL BO Name 3
Prompt Table: RF_IPRD_CSIT_VW
Set Control Field: SETID

12 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
Prompt Table: RF_INSP_AGR_VW

13 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID

14 INSPRD_PMSO_STATUS Character(3) VARCHAR2(3) NOT NULL Preventive Maintenance SO Status
CAN=Canceled
CMP=Completed
CRT=Created
INP=In Progress
PND=Pending

15 SO_DATE Date(10) DATE Stores the Service Order creation date.

16 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

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

18 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID

19 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: %EDITTABLE4

20 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

21 SHIP_DATE Date(10) DATE Item Shipping Date

22 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product

23 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
Prompt Table: DEPT_TBL

24 EXTERNAL_ID Character(20) VARCHAR2(20) NOT NULL External ID

25 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.

26 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

27 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

28 PARENT_INST_PRODID Character(20) VARCHAR2(20) NOT NULL This field is used to store the installed product ID of the parent installed product
Prompt Table: RF_IPRD_CUST_VW

29 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
Prompt Table: RF_INSP_AGR1_VW

30 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
Prompt Table: RF_INSP_AGR2_VW

31 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RFPMNONVW

32 CREATE_DATE Date(10) DATE Creation Date

33 COMMENTS254 Character(254) VARCHAR2(254) NOT NULL Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
4	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
5	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
6	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
7	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RF_PROD_PMPT_VW
8	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
9	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag
10	SITE_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.
11	BO_NAME_3	Character(50)	VARCHAR2(50) NOT NULL	BO Name 3 Prompt Table: RF_IPRD_CSIT_VW Set Control Field: SETID
12	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement Prompt Table: RF_INSP_AGR_VW
13	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID
14	INSPRD_PMSO_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Preventive Maintenance SO Status CAN=Canceled CMP=Completed CRT=Created INP=In Progress PND=Pending
15	SO_DATE	Date(10)	DATE	Stores the Service Order creation date.
16	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
17	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
18	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
19	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDITTABLE4
20	ORDER_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
21	SHIP_DATE	Date(10)	DATE	Item Shipping Date
22	INSTALLED_DATE	Date(10)	DATE	Field used for storing Installed Date of Installed product
23	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department Prompt Table: DEPT_TBL
24	EXTERNAL_ID	Character(20)	VARCHAR2(20) NOT NULL	External ID
25	LINE_NBR	Number(5,0)	INTEGER NOT NULL	This field represents the integer Order Line Number.
26	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
27	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
28	PARENT_INST_PRODID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store the installed product ID of the parent installed product Prompt Table: RF_IPRD_CUST_VW
29	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal) Prompt Table: RF_INSP_AGR1_VW
30	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number Prompt Table: RF_INSP_AGR2_VW
31	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RFPMNONVW
32	CREATE_DATE	Date(10)	DATE	Creation Date
33	COMMENTS254	Character(254)	VARCHAR2(254) NOT NULL	Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)