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

VIEW: APPS.CSI_T_PARTY_DETAILS_V

Object Details
Object Name: CSI_T_PARTY_DETAILS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


View for Transaction Party Details


[View Source]

Columns
Name Datatype Length Mandatory Comments
TXN_PARTY_DETAIL_ID NUMBER

Transaction Party Detail ID
TXN_LINE_DETAIL_ID NUMBER

Transaction Line Detail ID
PARTY_SOURCE_TABLE VARCHAR2 (30)
Party Source Table
PARTY_SOURCE_ID NUMBER

Party Source ID
RELATIONSHIP_TYPE_CODE VARCHAR2 (30)
Relationship Type Code
CONTACT_FLAG VARCHAR2 (1)
Contact Flag
CONTACT_PARTY_ID NUMBER

Contact Party ID
PRIMARY_FLAG VARCHAR2 (1)
Primary Flag
PREFERRED_FLAG VARCHAR2 (1)
Preferred Flag
ACTIVE_START_DATE DATE

Active Start Date
ACTIVE_END_DATE DATE

Active End Date
PARTY_NAME VARCHAR2 (360)
Party Name
PARTY_NUMBER VARCHAR2 (30)
Party Number
RELATIONSHIP_NAME VARCHAR2 (50)
Relationship Name
RELATIONSHIP_DESCR VARCHAR2 (240)
Relationship Description
PARTY_TYPE VARCHAR2 (80)
Party Type
Query Text

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


SELECT TXN_PARTY_DETAIL_ID
,      TXN_LINE_DETAIL_ID
,      PARTY_SOURCE_TABLE
,      PARTY_SOURCE_ID
,      RELATIONSHIP_TYPE_CODE
,      CONTACT_FLAG
,      CONTACT_PARTY_ID
,      PRIMARY_FLAG
,      PREFERRED_FLAG
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      PARTY_NAME
,      PARTY_NUMBER
,      RELATIONSHIP_NAME
,      RELATIONSHIP_DESCR
,      PARTY_TYPE
FROM APPS.CSI_T_PARTY_DETAILS_V;

Dependencies

[top of page]

APPS.CSI_T_PARTY_DETAILS_V references the following:

SchemaAPPS
SynonymCSI_IPA_RELATION_TYPES
ViewCSI_LOOKUPS
SynonymCSI_T_PARTY_DETAILS
SynonymHZ_PARTIES
ViewJTF_RS_GROUPS_VL
ViewJTF_RS_TEAMS_VL
SynonymPER_ALL_PEOPLE_F
ViewPO_VENDORS

APPS.CSI_T_PARTY_DETAILS_V is not referenced by any database object