View: PRP_PROP_OBJECTS_V

Product:	PRP - Proposals
Description:	This View Provides proposal and proposal objects details.
Implementation/DBA Data:	APPS.PRP_PROP_OBJECTS_V

View Text

SELECT PRP.PROPOSAL_ID
, PRP.USER_ID
, PRP.PARTY_ID
, PRP.CONTACT_PARTY_ID
, OBJ.OBJECT_ID
, OBJ.OBJECT_TYPE
, JRS.RESOURCE_NAME
, PRP.PROPOSAL_NAME
, PRP.PROPOSAL_DESC
, PRP.PROPOSAL_STATUS
, LUP.MEANING
, PRP.DUE_DATE
, DECODE(PRP.USER_ID
, FND_GLOBAL.USER_ID
, 'Y'
, 'N') UPDATEFLAG
, VERS.FILE_ID
, VERS.CITEM_VERSION_ID
, PRP.CONTENT_ITEM_ID
, PRP.PROPOSAL_LANGUAGE
FROM PRP_PROPOSALS PRP
, PRP_PROPOSAL_OBJECTS OBJ
, PRP_PROPOSAL_CTNTVERS VERS
, JTF_RS_RESOURCE_EXTNS_VL JRS
, FND_LOOKUP_VALUES LUP
WHERE PRP.PROPOSAL_ID = OBJ.PROPOSAL_ID
AND JRS.USER_ID = PRP.USER_ID
AND LUP.VIEW_APPLICATION_ID = 0
AND LUP.LOOKUP_TYPE = 'PRP_PROPOSAL_STATUS'
AND LUP.LOOKUP_CODE = PRP.PROPOSAL_STATUS
AND LUP.LANGUAGE = USERENV('LANG')
AND VERS.PROPOSAL_ID (+) = PRP.PROPOSAL_ID
AND VERS.MAX_VERSION_FLAG (+) = 'Y'

Columns