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

TABLE: BIL.BIL_BI_OPDTL_DENLOG_TMP

Object Details
Object Name: BIL_BI_OPDTL_DENLOG_TMP
Object Type: TABLE
Owner: BIL
FND Design Data: TableBIL.BIL_BI_OPDTL_DENLOG_TMP
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.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIL_BI_OPDTL_DENLOG_TMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnLEAD_ID
ColumnLEAD_LINE_ID
ColumnSALES_CREDIT_ID
BIL_BI_OPDTL_DENLOG_TMP_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnLAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
LEAD_ID NUMBER

Lead identifier
LEAD_LOG_ID NUMBER

Lead log id - from AS_LEADS_LOG table
LEAD_LINE_ID NUMBER

Lead line identifier
LEAD_LINE_LOG_ID NUMBER

Lead line log id - from AS_LEAD_LINES_LOG table
SALES_CREDIT_ID NUMBER

Sales credit identifier
SALES_CREDIT_LOG_ID NUMBER

Sales credit log id - from AS_SALES_CREDITS_LOG table
REV_FLAG VARCHAR2 (240)
Indicates whether this is a reversal row
CREATION_DATE DATE

Obsolete
LAST_UPDATE_DATE DATE

Last update date
CONVERSION_DATE DATE

Obsolete
SEQ_NO NUMBER

Stores row number
SECURITY_GROUP_ID NUMBER

Standard who column
Query Text

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


SELECT LEAD_ID
,      LEAD_LOG_ID
,      LEAD_LINE_ID
,      LEAD_LINE_LOG_ID
,      SALES_CREDIT_ID
,      SALES_CREDIT_LOG_ID
,      REV_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CONVERSION_DATE
,      SEQ_NO
,      SECURITY_GROUP_ID
FROM BIL.BIL_BI_OPDTL_DENLOG_TMP;

Dependencies

[top of page]

BIL.BIL_BI_OPDTL_DENLOG_TMP does not reference any database object

BIL.BIL_BI_OPDTL_DENLOG_TMP is referenced by following:

SchemaAPPS
SynonymBIL_BI_OPDTL_DENLOG_TMP