View: PA_PROJECT_REQUESTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJECT_REQUESTS_V

View Text

SELECT PR.ROWID
, PR.REQUEST_ID
, PR.REQUEST_NAME
, PR.REQUEST_NUMBER
, L.MEANING
, PS.PROJECT_STATUS_NAME
, PS.PROJECT_SYSTEM_STATUS_CODE
, PR.DESCRIPTION
, PR.EXPECTED_PROJECT_APPROVAL_DATE
, PR.CLOSED_DATE
, FA.APPLICATION_NAME
, PR.SOURCE_REFERENCE
, PR.VALUE
, PR.CURRENCY_CODE
, HP.PARTY_NAME
, HP.PARTY_NUMBER
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.CITY
, HL.COUNTY
, HL.STATE
, HL.PROVINCE
, HL.COUNTRY
, HL.POSTAL_CODE
, HL.ADDRESS_LINES_PHONETIC
, HCA.ACCOUNT_NUMBER
, HCA.ACCOUNT_NAME
, FND_ACCESS_CONTROL_UTIL.GET_ORG_NAME(PR.SOURCE_ORG_ID)
, PR.RECORD_VERSION_NUMBER
FROM PA_PROJECT_REQUESTS PR
, PA_LOOKUPS L
, PA_PROJECT_STATUSES PS
, FND_APPLICATION_TL FA
, HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, HZ_CUST_ACCOUNTS HCA
WHERE L.LOOKUP_TYPE ='PROJECT_REQUEST_TYPE'
AND PR.REQUEST_TYPE = L.LOOKUP_CODE
AND PS.STATUS_TYPE='PROJ_REQ'
AND PS.PROJECT_STATUS_CODE = PR.STATUS_CODE
AND PR.APPLICATION_ID = FA.APPLICATION_ID(+)
AND NVL(FA.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND PR.CUST_PARTY_ID = HP.PARTY_ID(+)
AND PR.CUST_PARTY_SITE_ID = HPS.PARTY_SITE_ID(+)
AND PR.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID(+)
AND HPS.LOCATION_ID =HL.LOCATION_ID(+)

Columns