[Home] [Help]
View: PV_PARTNER_VENDORS_V
View Text
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
Columns
| Name |
| ID1 |
| ID2 |
| DESCRIPTION |
| PARTY_NUMBER |
| NAME |
| PARTY_TYPE |
| B_STATUS |
| STATUS |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
APPS.PV_PARTNER_VENDORS_V