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

VIEW: APPS.JTF_PARTY_LOCATIONS_V

Object Details
Object Name: JTF_PARTY_LOCATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_PARTY_LOCATIONS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


JTF_PARTY_LOCATIONS_V display address information about a party. This includes displaying information from HZ_PARTIES, HZ_LOCATION and the table joining these two, HZ_PARTY_SITES. A Party can have one-to-many addresses and an address can be used by multiple parties, hence a join/intersection table. For the intersection table.
For every location a party have there can be one-to-many usages of a location, hence this view also join with HZ_PARTY_SITE_USES (for bill-to, ship_to etc. information).


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
PARTY_ID NUMBER (15) Yes Identifier of the party to which this location is associated to. Foreign key to HZ_PARTIES
PARTY_NUMBER VARCHAR2 (30) Yes Party number to which this location is associated to
PARTY_NAME VARCHAR2 (360) Yes Name of the party this location is associated to
PARTY_TYPE VARCHAR2 (30) Yes Type of the Party this location is associated to. Organization or Group or Person or Party Relationship
LOCATION_ID NUMBER (15) Yes Location identifier
PARTY_SITE_ID NUMBER (15) Yes Party site identifier
PARTY_SITE_USE_ID NUMBER (15)
Party site use identifier
STATUS VARCHAR2 (1) Yes Party site status flag.
TYPE VARCHAR2 (30)
Site use type
ADDRESS VARCHAR2 (963)
Concatenated address information
ADDRESS1 VARCHAR2 (240) Yes First line of address
ADDRESS2 VARCHAR2 (240)
Second line of address
ADDRESS3 VARCHAR2 (240)
Third line of address
ADDRESS4 VARCHAR2 (240)
Fourth line of address
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
POSTAL_CODE VARCHAR2 (60)
Postal Code
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (60) Yes Country
PRIMARY_FLAG VARCHAR2 (1) Yes Y or N indicates whether this is the primary address for the party
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
SITE_LAST_UPDATE_DATE DATE
Yes Standard Who Column
USE_LAST_UPDATE_DATE DATE

Standard Who Column
Query Text

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


SELECT ROW_ID
,      PARTY_ID
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_TYPE
,      LOCATION_ID
,      PARTY_SITE_ID
,      PARTY_SITE_USE_ID
,      STATUS
,      TYPE
,      ADDRESS
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      PROVINCE
,      POSTAL_CODE
,      COUNTY
,      COUNTRY
,      PRIMARY_FLAG
,      LAST_UPDATE_DATE
,      SITE_LAST_UPDATE_DATE
,      USE_LAST_UPDATE_DATE
FROM APPS.JTF_PARTY_LOCATIONS_V;

Dependencies

[top of page]

APPS.JTF_PARTY_LOCATIONS_V references the following:

SchemaAPPS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_PARTY_SITE_USES
APPS.JTF_PARTY_LOCATIONS_V is referenced by following:

SchemaAPPS
Package BodyCSP_PARTS_REQUIREMENT - show dependent code