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


VIEW: APPS.OE_LINE_SAL_CRDT_HIST_V

Object Details
Object Name: OE_LINE_SAL_CRDT_HIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_LINE_SAL_CRDT_HIST_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
USER_ID NUMBER

Standard Who column
RESPONSIBILITY_ID NUMBER
Yes Responsibility using which sales credit was changed.
HIST_CREATION_DATE DATE

History creation date.
HEADER_ID NUMBER

Foreign Key to indicate Header
LINE_ID NUMBER

Foreign Key to indicate Line
SALES_CREDIT_ID NUMBER

System generated ID
SOLD_TO_ORG_ID NUMBER

Sold to customer
ORDER_TYPE_ID NUMBER
Yes Order Transaction Type Identifier
ORDER_NUMBER NUMBER
Yes User-visible number of the order
LINE_NUMBER NUMBER
Yes Line sequence number within the order
REASON_CODE VARCHAR2 (30)
Reason code for which sales credit attributes changed.
HIST_COMMENTS VARCHAR2 (2000)
Comments for sales credit attributes changed.
HIST_TYPE_CODE VARCHAR2 (30)
Type of transaction for which history was created.
SALESREP_ID NUMBER (15)
Sales person
PERCENT NUMBER

Value to indicate Sales Credit percent for a sales person
SALES_CREDIT_TYPE_ID NUMBER

Stores Foreign key to point to sales credit type
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REASON_ID NUMBER

AUDIT_FLAG VARCHAR2 (1)
VERSION_FLAG VARCHAR2 (1)
PHASE_CHANGE_FLAG VARCHAR2 (1)
VERSION_NUMBER NUMBER

Query Text

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


SELECT USER_ID
,      RESPONSIBILITY_ID
,      HIST_CREATION_DATE
,      HEADER_ID
,      LINE_ID
,      SALES_CREDIT_ID
,      SOLD_TO_ORG_ID
,      ORDER_TYPE_ID
,      ORDER_NUMBER
,      LINE_NUMBER
,      REASON_CODE
,      HIST_COMMENTS
,      HIST_TYPE_CODE
,      SALESREP_ID
,      PERCENT
,      SALES_CREDIT_TYPE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REASON_ID
,      AUDIT_FLAG
,      VERSION_FLAG
,      PHASE_CHANGE_FLAG
,      VERSION_NUMBER
FROM APPS.OE_LINE_SAL_CRDT_HIST_V;

Dependencies

[top of page]

APPS.OE_LINE_SAL_CRDT_HIST_V references the following:

SchemaAPPS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOE_SALES_CREDIT_HISTORY

APPS.OE_LINE_SAL_CRDT_HIST_V is not referenced by any database object