RF_IPRD_SRCH_VW(SQL View) |
Index Back |
|---|---|
Installed Product Search ViewInstalled Product Search Record View |
| SELECT A.SETID , A.INST_PROD_ID , A.INST_PROD_TYPE , C.BO_NAME , C.BO_NAME_AC , A.PRODUCT_ID , A.INV_ITEM_ID , A.SERIAL_ID , A.ASSETTAG , D.BO_NAME , D.BO_NAME_AC , A.CAPTURE_ID , A.EXTERNAL_ID , A.SITE_ID , H.BO_NAME , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , F.BO_NAME , F.BO_NAME_AC , G.BO_NAME_DISPLAY , G.BO_NAME_AC , F.BO_ID , G.BO_ID_PTNR_CNT , A.ROLETYPE_PTNR_CMP , A.ROLETYPE_PTNR_CNT , A.SYNCID , A.SYNCDTTM FROM PS_RF_INST_PROD A , PS_BO_NAME C , PS_BC E , PS_BO_NAME D , PS_RD_PTNR_SRCH_VW F , PS_RF_PRSN_PC_VW G , PS_RF_SITE_P_NM_VW H WHERE A.BO_ID_CUST = C.BO_ID(+) AND C.PRIMARY_IND(+) = 'Y' AND A.BO_ID_CUST = E.BO_ID(+) AND A.BO_ID_CONTACT = D.BO_ID(+) AND D.PRIMARY_IND(+) = 'Y' AND A.BO_ID_PTNR_CMP = F.BO_ID(+) AND F.PARTNER_STATUS(+) = '1' AND A.BO_ID_PTNR_CNT = G.BO_ID_PTNR_CNT(+) AND A.SETID = H.SETCNTRLVALUE(+) AND A.SITE_ID = H.SITE_ID(+) AND A.INST_PROD_TYPE IN ('002', '003', '004') |
| # | 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 | INST_PROD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements).
001=Asset 002=Product 003=Service 004=Agreement 005=Commitment |
| 4 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: RF_IPRD_PRD_VW |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: RF_IPRD_ITM_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
Prompt Table: RF_IPRD_SN_VW |
| 9 | ASSETTAG | Character(40) | VARCHAR2(40) NOT NULL |
Asset Tag
Prompt Table: RF_IPRD_AT_VW |
| 10 | BO_NAME_2 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 2 |
| 11 | BO_NAME_1 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 1 |
| 12 | CAPTURE_ID | Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 13 | EXTERNAL_ID | Character(20) | VARCHAR2(20) NOT NULL | External ID |
| 14 | 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. |
| 15 | BO_NAME_3 | Character(50) | VARCHAR2(50) NOT NULL |
BO Name 3
Prompt Table:
RF_IPRD_CSIT_VW
|
| 16 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 17 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 18 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 19 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 20 | BO_NAME_PTNR_CMP | Character(50) | VARCHAR2(50) NOT NULL | Partner Company Name identifying a Partner Company. |
| 21 | BO_NAME_CMP_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Partner Company Name. |
| 22 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 23 | BO_NAME_CONTACT_AC | Character(50) | VARCHAR2(50) NOT NULL | Alt-Char Contact Name |
| 24 | BO_ID_PTNR_CMP | Signed Number(32,0) | DECIMAL(31) NOT NULL | Partner Company Business Object ID. |
| 25 | BO_ID_PTNR_CNT | Signed Number(32,0) | DECIMAL(31) NOT NULL | Partner Contact Business Object ID. |
| 26 | ROLETYPE_PTNR_CMP | Number(12,0) | DECIMAL(12) NOT NULL | Role Type Partner Company |
| 27 | ROLETYPE_PTNR_CNT | Number(12,0) | DECIMAL(12) NOT NULL | Role Type Partner Contact |
| 28 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 29 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |