eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PV_PARTNER_VENDORS_V

Source

View Text - Preformatted


SELECT party.party_id ID1, '#' ID2, party.PARTY_NUMBER DESCRIPTION , party.PARTY_NUMBER PARTY_NUMBER, party.party_name NAME, party.party_type, party.status B_STATUS, party.status STATUS, sysdate START_DATE_ACTIVE, org_profile.effective_end_date END_DATE_ACTIVE from hz_parties party, hz_organization_profiles org_profile WHERE party.party_id = org_profile.party_id and org_profile.internal_flag = 'Y' and org_profile.effective_end_date is null

View Text - HTML Formatted

SELECT PARTY.PARTY_ID ID1
, '#' ID2
, PARTY.PARTY_NUMBER DESCRIPTION
, PARTY.PARTY_NUMBER PARTY_NUMBER
, PARTY.PARTY_NAME NAME
, PARTY.PARTY_TYPE
, PARTY.STATUS B_STATUS
, PARTY.STATUS STATUS
, SYSDATE START_DATE_ACTIVE
, ORG_PROFILE.EFFECTIVE_END_DATE END_DATE_ACTIVE
FROM HZ_PARTIES PARTY
, HZ_ORGANIZATION_PROFILES ORG_PROFILE
WHERE PARTY.PARTY_ID = ORG_PROFILE.PARTY_ID
AND ORG_PROFILE.INTERNAL_FLAG = 'Y'
AND ORG_PROFILE.EFFECTIVE_END_DATE IS NULL