VIEW: APPS.PA_PROJECT_REQUESTS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)