View: AST_PARTNER_LOV_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_PARTNER_LOV_V

View Text

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)

Columns