VIEW: APPS.PRP_PROP_OBJECTS_V

Source

View Text - Preformatted

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 ,formats.file_id ,formats.file_format ,null citem_version_id ,null 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, prp_prop_ctntver_formats formats, prp_proposal_accesses accesses WHERE prp.proposal_id = obj.proposal_id AND jrs.resource_id = accesses.resource_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' AND formats.proposal_ctntver_id (+) = vers.proposal_ctntver_id AND NVL(formats.file_format,'RTF') = DECODE ((Select count(*) from PRP_PROP_CTNTVER_FORMATS where file_format = 'PDF' and proposal_ctntver_id = vers.proposal_ctntver_id), 1, 'PDF', NVL(formats.file_format,'RTF')) AND accesses.proposal_id = prp.proposal_id AND accesses.owner_flag = 'Y'

View Text - HTML Formatted

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
, FORMATS.FILE_ID
, FORMATS.FILE_FORMAT
, NULL CITEM_VERSION_ID
, NULL 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
, PRP_PROP_CTNTVER_FORMATS FORMATS
, PRP_PROPOSAL_ACCESSES ACCESSES
WHERE PRP.PROPOSAL_ID = OBJ.PROPOSAL_ID
AND JRS.RESOURCE_ID = ACCESSES.RESOURCE_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'
AND FORMATS.PROPOSAL_CTNTVER_ID (+) = VERS.PROPOSAL_CTNTVER_ID
AND NVL(FORMATS.FILE_FORMAT
, 'RTF') = DECODE ((SELECT COUNT(*)
FROM PRP_PROP_CTNTVER_FORMATS
WHERE FILE_FORMAT = 'PDF'
AND PROPOSAL_CTNTVER_ID = VERS.PROPOSAL_CTNTVER_ID)
, 1
, 'PDF'
, NVL(FORMATS.FILE_FORMAT
, 'RTF'))
AND ACCESSES.PROPOSAL_ID = PRP.PROPOSAL_ID
AND ACCESSES.OWNER_FLAG = 'Y'