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

VIEW: APPS.CN_ADJ_DETAIL_LINES_V

Object Details
Object Name: CN_ADJ_DETAIL_LINES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMMISSION_LINE_ID NUMBER (15) Yes Foreign key to cn_commission_lines
ORG_ID NUMBER (15)
OrgId
COMMISSION_HEADER_ID NUMBER (15)
Foreign key to cn_commission_headers.
CREDITED_SALESREP_ID NUMBER (15)
Which salesrep may be payed for this revenue
CREDITED_SALESREP_NAME VARCHAR2 (360)
Credited Salesrep Name
CREDITED_SALESREP_NUMBER VARCHAR2 (30)
Credited Salesrep Number
PROCESSED_PERIOD_ID NUMBER (15)
Period in which revenue is recognized
PROCESSED_DATE DATE

Date on which revenue was recognized
PLAN_ELEMENT VARCHAR2 (80)
Plan element.
PAYMENT_UPLIFT NUMBER

Payment uplift.
QUOTA_UPLIFT NUMBER

Quota uplift.
COMMISSION_AMOUNT NUMBER

Commission amount.
COMMISSION_RATE NUMBER

Commission rate.
CREATED_DURING VARCHAR2 (30)
Created during.
PAY_PERIOD VARCHAR2 (30)
Pay period.
ACCUMULATION_PERIOD VARCHAR2 (30)
Accumulation period.
PERF_ACHIEVED NUMBER

Performance achieved amount.
POSTING_STATUS VARCHAR2 (30)
Posting status.
PENDING_STATUS VARCHAR2 (30)
Pending status.
TRX_STATUS VARCHAR2 (80)
Trx Status
PAYEE VARCHAR2 (360)
Payee.
Query Text

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


SELECT COMMISSION_LINE_ID
,      ORG_ID
,      COMMISSION_HEADER_ID
,      CREDITED_SALESREP_ID
,      CREDITED_SALESREP_NAME
,      CREDITED_SALESREP_NUMBER
,      PROCESSED_PERIOD_ID
,      PROCESSED_DATE
,      PLAN_ELEMENT
,      PAYMENT_UPLIFT
,      QUOTA_UPLIFT
,      COMMISSION_AMOUNT
,      COMMISSION_RATE
,      CREATED_DURING
,      PAY_PERIOD
,      ACCUMULATION_PERIOD
,      PERF_ACHIEVED
,      POSTING_STATUS
,      PENDING_STATUS
,      TRX_STATUS
,      PAYEE
FROM APPS.CN_ADJ_DETAIL_LINES_V;

Dependencies

[top of page]

APPS.CN_ADJ_DETAIL_LINES_V references the following:

SchemaAPPS
ViewCN_ACC_PERIOD_STATUSES_V
SynonymCN_COMMISSION_LINES
ViewCN_LOOKUPS
SynonymCN_QUOTAS
ViewCN_SALESREPS
SynonymCN_SRP_PAYEE_ASSIGNS
APPS.CN_ADJ_DETAIL_LINES_V is referenced by following:

SchemaAPPS
Package BodyCN_GET_TX_DATA_PUB - show dependent code