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

VIEW: OSM.AS_SALES_CREDIT_ADJS#

Object Details
Object Name: AS_SALES_CREDIT_ADJS#
Object Type: VIEW
Owner: OSM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SALES_CREDIT_ADJUSTMENT_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
LEAD_ADJUSTMENT_ID NUMBER
Yes
LEAD_LINE_ADJUSTMENT_ID NUMBER
Yes
ORIGINAL_LEAD_ID NUMBER
Yes
ORIGINAL_LEAD_LINE_ID NUMBER
Yes
ORIGINAL_SALES_CREDIT_ID NUMBER
Yes
ORIGINAL_SALES_CREDIT_FLAG VARCHAR2 (1) Yes
SALESFORCE_ID NUMBER

PERSON_ID NUMBER

SALES_GROUP_ID NUMBER

PARTNER_CUSTOMER_ID NUMBER

PARTNER_ADDRESS_ID NUMBER

REVENUE_PERCENT NUMBER

ADJUSTED_BY_PERSON_ID NUMBER
Yes
Query Text

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


SELECT SALES_CREDIT_ADJUSTMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LEAD_ADJUSTMENT_ID
,      LEAD_LINE_ADJUSTMENT_ID
,      ORIGINAL_LEAD_ID
,      ORIGINAL_LEAD_LINE_ID
,      ORIGINAL_SALES_CREDIT_ID
,      ORIGINAL_SALES_CREDIT_FLAG
,      SALESFORCE_ID
,      PERSON_ID
,      SALES_GROUP_ID
,      PARTNER_CUSTOMER_ID
,      PARTNER_ADDRESS_ID
,      REVENUE_PERCENT
,      ADJUSTED_BY_PERSON_ID
FROM OSM.AS_SALES_CREDIT_ADJS#;

Dependencies

[top of page]

OSM.AS_SALES_CREDIT_ADJS# references the following:

SchemaOSM
TableAS_SALES_CREDIT_ADJS
OSM.AS_SALES_CREDIT_ADJS# is referenced by following:

SchemaAPPS
SynonymAS_SALES_CREDIT_ADJS