[Home] [Help] [Dependency Information]
Object Name: | CSC_HZ_PARTY_RELATIONSHIPS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_HZ_PARTY_RELATIONSHIPS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Standard Row ID column | |
PARTY_ID | NUMBER | (15) | Party Identifier | |
PARTY_RELATIONSHIP_ID | NUMBER | (15) | Yes | Party Relationship identifier |
PARTY_NUMBER | VARCHAR2 | (30) | party number | |
SUBJECT_ID | NUMBER | (15) | Yes | Party Identifier |
OBJECT_ID | NUMBER | (15) | Yes | Party Identifier |
OBJ_PARTY_TYPE | VARCHAR2 | (30) | Yes | Type of party. This is limited to person, organization, group or relationship. |
SUB_PARTY_TYPE | VARCHAR2 | (30) | Yes | Type of party. This is limited to person, organization, group or relationship. |
RELATION | VARCHAR2 | (30) | Yes | Lookup: party_relationship_type. |
OBJECT_NAME | VARCHAR2 | (360) | Yes | Party name |
SUB_PARTY_NAME | VARCHAR2 | (360) | Yes | Party name |
SUB_JOB_TITLE | VARCHAR2 | (30) | Job title of the contact | |
OBJ_LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
EFFECTIVE_START_DATE | DATE | Yes | Date relationship begins | |
EFFECTIVE_END_DATE | DATE | Date relationship ends | ||
STATUS | VARCHAR2 | (1) | Yes | Party relationship status flag |
COMMENTS | VARCHAR2 | (240) | User comments | |
DIRECTIONAL_FLAG | VARCHAR2 | (1) | Yes | Specifies the Direction of the Relationship |
RELATIONSHIP_CODE | VARCHAR2 | (30) | Yes | Lookup: party_relationship_type. |
RELATIONSHIP_MEANING | VARCHAR2 | (80) | Yes | Lookup: party_relationship_type meaning |
OBJECT_VERSION_NUMBER | NUMBER | object version number for hz_relationships | ||
PARTY_OBJECT_VERSION_NUMBER | NUMBER | object version number for hz_parties |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PARTY_ID
, PARTY_RELATIONSHIP_ID
, PARTY_NUMBER
, SUBJECT_ID
, OBJECT_ID
, OBJ_PARTY_TYPE
, SUB_PARTY_TYPE
, RELATION
, OBJECT_NAME
, SUB_PARTY_NAME
, SUB_JOB_TITLE
, OBJ_LAST_UPDATE_DATE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, STATUS
, COMMENTS
, DIRECTIONAL_FLAG
, RELATIONSHIP_CODE
, RELATIONSHIP_MEANING
, OBJECT_VERSION_NUMBER
, PARTY_OBJECT_VERSION_NUMBER
FROM APPS.CSC_HZ_PARTY_RELATIONSHIPS_V;
APPS.CSC_HZ_PARTY_RELATIONSHIPS_V is not referenced by any database object
|
|
|