[Home] [Help] [Dependency Information]
Object Name: | IEX_DUNNINGS_BALI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELINQUENCY_ID | NUMBER | |||
DUNNING_ID | NUMBER | |||
STATUS | VARCHAR2 | (240) | ||
STATUS_MEANING | VARCHAR2 | (4000) | ||
CREATION_DATE | DATE | |||
TEMPLATE_NAME | VARCHAR2 | (120) | ||
AGING_BUCKET_LINE_ID | VARCHAR2 | (0) | ||
PARTY_CUST_ID | NUMBER | |||
ACCOUNT_ID | NUMBER | |||
CUSTOMER_SITE_USE_ID | NUMBER | |||
BUCKET_LINE | VARCHAR2 | (30) | ||
DUNNING_METHOD | VARCHAR2 | (30) | ||
DUNNING_METHOD_MEANING | VARCHAR2 | (4000) | ||
DUNNING_TYPE | VARCHAR2 | (30) | ||
DUNNING_TYPE_MEANING | VARCHAR2 | (4000) | ||
AMOUNT_DUE_REMAINING | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
OBJECT_ID | NUMBER | |||
OBJECT_TYPE | VARCHAR2 | (4000) | ||
DUNNING_OBJECT_ID | NUMBER | |||
DUNNING_LEVEL | VARCHAR2 | (30) | ||
DUNNING_LEVEL_MEANING | VARCHAR2 | (4000) | ||
FFM_REQUEST_ID | NUMBER | |||
FFM_STATUS | VARCHAR2 | (40) | ||
PAYMENT_SCHEDULE_ID | NUMBER | |||
TRX_NUMBER | VARCHAR2 | (20) | ||
CUSTOMER_TRX_ID | NUMBER | |||
TERMS_SEQUENCE_NUMBER | NUMBER | |||
DUE_DATE | DATE | |||
PURCHASE_ORDER | VARCHAR2 | (50) | ||
SALES_ORDER | CHAR | (0) | ||
CUST_TRX_CLASS_NAME | VARCHAR2 | (4000) | ||
FINANCIAL_CHARGE | NUMBER | |||
LETTER_NAME | VARCHAR2 | (0) | ||
INTEREST_AMT | NUMBER | |||
CONS_BILLING_NUMBER | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | |||
OPERATING_UNIT | VARCHAR2 | (240) | ||
OBJECT_TYPE_MEANING | VARCHAR2 | (30) | ||
DUNNING_PLAN_ID | NUMBER | |||
DUNNING_PLAN_NAME | VARCHAR2 | (240) | ||
CONTACT_DESTINATION | VARCHAR2 | (2000) | ||
CONTACT_PARTY_ID | NUMBER | |||
CONTACT_PARTY_NAME | VARCHAR2 | (360) | ||
PARENT_DUNNING_ID | NUMBER | |||
DUNNING_MODE | VARCHAR2 | (4000) | ||
CONFIRMATION_MODE | VARCHAR2 | (4000) | ||
DUNNING_ERROR | VARCHAR2 | (4000) | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | (240) | ||
DOCUMENT_TYPE_MEANING | VARCHAR2 | (4000) | ||
ADDT_STATUS | VARCHAR2 | (75) |
Cut, paste (and edit) the following text to query this object:
SELECT DELINQUENCY_ID
, DUNNING_ID
, STATUS
, STATUS_MEANING
, CREATION_DATE
, TEMPLATE_NAME
, AGING_BUCKET_LINE_ID
, PARTY_CUST_ID
, ACCOUNT_ID
, CUSTOMER_SITE_USE_ID
, BUCKET_LINE
, DUNNING_METHOD
, DUNNING_METHOD_MEANING
, DUNNING_TYPE
, DUNNING_TYPE_MEANING
, AMOUNT_DUE_REMAINING
, CURRENCY_CODE
, OBJECT_ID
, OBJECT_TYPE
, DUNNING_OBJECT_ID
, DUNNING_LEVEL
, DUNNING_LEVEL_MEANING
, FFM_REQUEST_ID
, FFM_STATUS
, PAYMENT_SCHEDULE_ID
, TRX_NUMBER
, CUSTOMER_TRX_ID
, TERMS_SEQUENCE_NUMBER
, DUE_DATE
, PURCHASE_ORDER
, SALES_ORDER
, CUST_TRX_CLASS_NAME
, FINANCIAL_CHARGE
, LETTER_NAME
, INTEREST_AMT
, CONS_BILLING_NUMBER
, ORG_ID
, OPERATING_UNIT
, OBJECT_TYPE_MEANING
, DUNNING_PLAN_ID
, DUNNING_PLAN_NAME
, CONTACT_DESTINATION
, CONTACT_PARTY_ID
, CONTACT_PARTY_NAME
, PARENT_DUNNING_ID
, DUNNING_MODE
, CONFIRMATION_MODE
, DUNNING_ERROR
, DOCUMENT_TYPE_CODE
, DOCUMENT_TYPE_MEANING
, ADDT_STATUS
FROM APPS.IEX_DUNNINGS_BALI_V;
APPS.IEX_DUNNINGS_BALI_V is not referenced by any database object
|
|
|