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

VIEW: APPS.XTR_A_COUNTERPARTY_LIMITS_V

Object Details
Object Name: XTR_A_COUNTERPARTY_LIMITS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_A_COUNTERPARTY_LIMITS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_CODE VARCHAR2 (7) Yes
LIMIT_CODE VARCHAR2 (7) Yes
CPARTY_CODE VARCHAR2 (7) Yes
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
LIMIT_AMOUNT NUMBER

SEQUENCE_NUMBER NUMBER

INITIAL_FEE_DATE DATE

EXPIRY_DATE DATE

UTILISATION_FEE_PERCENT NUMBER

COMMITMENT_FEE_PERCENT NUMBER

FREQUENCY NUMBER

UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

AUTHORISED VARCHAR2 (1)
LIMIT_TYPE VARCHAR2 (2)
CROSS_ALLOCATION_GROUP_CODE VARCHAR2 (15)
UTILISED_AMOUNT NUMBER

UTILIZATION_STRUCTURE_BASIS VARCHAR2 (1)
UTILISATION_CALC_BASIS VARCHAR2 (1)
BENCHMARK_REF VARCHAR2 (20)
AUDIT_INDICATOR VARCHAR2 (1)
AUDIT_DATE_STORED DATE

Query Text

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


SELECT COMPANY_CODE
,      LIMIT_CODE
,      CPARTY_CODE
,      CREATED_BY
,      CREATED_ON
,      LIMIT_AMOUNT
,      SEQUENCE_NUMBER
,      INITIAL_FEE_DATE
,      EXPIRY_DATE
,      UTILISATION_FEE_PERCENT
,      COMMITMENT_FEE_PERCENT
,      FREQUENCY
,      UPDATED_BY
,      UPDATED_ON
,      AUTHORISED
,      LIMIT_TYPE
,      CROSS_ALLOCATION_GROUP_CODE
,      UTILISED_AMOUNT
,      UTILIZATION_STRUCTURE_BASIS
,      UTILISATION_CALC_BASIS
,      BENCHMARK_REF
,      AUDIT_INDICATOR
,      AUDIT_DATE_STORED
FROM APPS.XTR_A_COUNTERPARTY_LIMITS_V;

Dependencies

[top of page]

APPS.XTR_A_COUNTERPARTY_LIMITS_V references the following:

SchemaAPPS
SynonymXTR_A_COUNTERPARTY_LIMITS

APPS.XTR_A_COUNTERPARTY_LIMITS_V is not referenced by any database object