VIEW: APPS.AST_PARTNER_LOV_V

Source

View Text - Preformatted

SELECT a.source_id, b.party_name, b.party_type, b.status, a.resource_id, b.address1, b.address2, b.address3, b.address4, b.city, b.state, b.county, b.province, b.postal_code, c.territory_short_name FROM JTF_RS_RESOURCE_EXTNS a, HZ_PARTIES b, FND_TERRITORIES_TL c WHERE a.source_id=b.party_id AND a.category='PARTNER' AND b. country = c.territory_code (+) AND trunc(sysdate) BETWEEN a.start_date_active AND nvl(a.end_date_active,sysdate)

View Text - HTML Formatted

SELECT A.SOURCE_ID
, B.PARTY_NAME
, B.PARTY_TYPE
, B.STATUS
, A.RESOURCE_ID
, B.ADDRESS1
, B.ADDRESS2
, B.ADDRESS3
, B.ADDRESS4
, B.CITY
, B.STATE
, B.COUNTY
, B.PROVINCE
, B.POSTAL_CODE
, C.TERRITORY_SHORT_NAME
FROM JTF_RS_RESOURCE_EXTNS A
, HZ_PARTIES B
, FND_TERRITORIES_TL C
WHERE A.SOURCE_ID=B.PARTY_ID
AND A.CATEGORY='PARTNER'
AND B. COUNTRY = C.TERRITORY_CODE (+)
AND TRUNC(SYSDATE) BETWEEN A.START_DATE_ACTIVE
AND NVL(A.END_DATE_ACTIVE
, SYSDATE)