RSF_PG_OPP_VW (SQL View)	Index Back
Opp Product Group Access View

RSF_PG_OPP_VW

(SQL View)

Opp Product Group Access View

SELECT DISTINCT O.OPPORTUNITY_ID , AC.PERSON_ID , O.OPPORTUNITY_NAME , O.OPPORTUNITY_STATUS , O.BUSINESS_UNIT , O.PROD_GRP_SETID , P.PRODUCT_GROUP , P.PROD_SETID , P.PRODUCT_ID , %subrec(RB_MARKET_SBR, O) , %subrec(RB_AUDIT_SBR, O) FROM PS_RSF_OPPORTUNITY O , PS_RSF_OPP_PRODUCT P , PS_RSF_ACC_PG_VW AC WHERE O.OPPORTUNITY_ID = P.OPPORTUNITY_ID AND O.BUSINESS_UNIT = AC.BUSINESS_UNIT AND P.PRODUCT_GROUP <> ' ' AND ( (AC.CRITERIA_TYPE = 'S' AND P.PRODUCT_GROUP = AC.CRITERIA_VALUE) OR (AC.CRITERIA_TYPE = 'R' AND P.PRODUCT_GROUP >= AC.FROM_CRIT_VALUE AND P.PRODUCT_GROUP <= AC.TO_CRIT_VALUE) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
Default Value: NEXT

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 OPPORTUNITY_NAME Character(50) VARCHAR2(50) NOT NULL Opportunity Name - User Enters this field in Mixed Case.

4 OPPORTUNITY_STATUS Character(1) VARCHAR2(1) NOT NULL Opportunity Status. The values are XLat Values
0=Open
1=Closed - Lost
2=Closed - Won
3=Inactive
Default Value: 0

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: RSF_OPR_DEF_VW.BUSINESS_UNIT
Prompt Table: SP_BU_RSF_NONVW

6 PROD_GRP_SETID Character(5) VARCHAR2(5) NOT NULL Product Group SetID

7 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group
Prompt Table: RSF_PRODGRP_VW

8 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID

9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: RSF_PROD_VW

10 MARKET Character(3) VARCHAR2(3) NOT NULL Market

11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

15 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.

16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID Default Value: NEXT
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	OPPORTUNITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Opportunity Name - User Enters this field in Mixed Case.
4	OPPORTUNITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Opportunity Status. The values are XLat Values 0=Open 1=Closed - Lost 2=Closed - Won 3=Inactive Default Value: 0
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: RSF_OPR_DEF_VW.BUSINESS_UNIT Prompt Table: SP_BU_RSF_NONVW
6	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
7	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group Prompt Table: RSF_PRODGRP_VW
8	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SET ID
9	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RSF_PROD_VW
10	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
11	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
12	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
13	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
14	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
15	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.
16	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time