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

VIEW: APPS.IEX_PAY_OKL_CONTRACTS_V

Object Details
Object Name: IEX_PAY_OKL_CONTRACTS_V
Object Type: VIEW
Owner: APPS
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
CASE_ID NUMBER
Yes
CASE_NUMBER NUMBER
Yes
CASE_STATUS VARCHAR2 (0)
CASE_STATUS_DSP VARCHAR2 (0)
CONTRACT_ID NUMBER
Yes
CONTRACT_NUMBER VARCHAR2 (120) Yes
CUSTOMER_ID NUMBER
Yes
CUSTOMER_NUMBER VARCHAR2 (30) Yes
AMOUNT NUMBER

CURRENCY_CODE VARCHAR2 (15)
DELINQUENCY_ID VARCHAR2 (0)
CUSTOMER_SITE_USE_ID NUMBER (15)
Query Text

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


SELECT CASE_ID
,      CASE_NUMBER
,      CASE_STATUS
,      CASE_STATUS_DSP
,      CONTRACT_ID
,      CONTRACT_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      AMOUNT
,      CURRENCY_CODE
,      DELINQUENCY_ID
,      CUSTOMER_SITE_USE_ID
FROM APPS.IEX_PAY_OKL_CONTRACTS_V;

Dependencies

[top of page]

APPS.IEX_PAY_OKL_CONTRACTS_V references the following:

SchemaAPPS
ViewIEX_BPD_CONTRACT_REMAINING_V
SynonymIEX_CASE_OBJECTS

APPS.IEX_PAY_OKL_CONTRACTS_V is not referenced by any database object