DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.ZX_FIRST_PARTY_ORGS_ALL_V

Object Details
Object Name: ZX_FIRST_PARTY_ORGS_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.ZX_FIRST_PARTY_ORGS_ALL_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_TAX_PROFILE_ID NUMBER (15)
PARTY_NAME VARCHAR2 (240)
PARTY_TYPE_CODE VARCHAR2 (30)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
TOWN_OR_CITY VARCHAR2 (30)
REGION_1 VARCHAR2 (120)
REGION_2 VARCHAR2 (120)
POSTAL_CODE VARCHAR2 (30)
COUNTRY_CODE VARCHAR2 (60)
USE_LE_AS_SUBSCRIBER_FLAG VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARTY_TAX_PROFILE_ID
,      PARTY_NAME
,      PARTY_TYPE_CODE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      REGION_1
,      REGION_2
,      POSTAL_CODE
,      COUNTRY_CODE
,      USE_LE_AS_SUBSCRIBER_FLAG
FROM APPS.ZX_FIRST_PARTY_ORGS_ALL_V;

Dependencies

[top of page]

APPS.ZX_FIRST_PARTY_ORGS_ALL_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_LOCATIONS_ALL
ViewHR_OPERATING_UNITS
SynonymHZ_PARTIES
SynonymXLE_ENTITY_PROFILES
SynonymXLE_REGISTRATIONS
SynonymZX_PARTY_TAX_PROFILE
APPS.ZX_FIRST_PARTY_ORGS_ALL_V is referenced by following:

SchemaAPPS
ViewZX_ACCOUNT_RATES_NEW_V
ViewZX_ACCOUNT_RATES_V