VIEW: APPS.CN_ADJ_DETAIL_LINES_V

Source

View Text - Preformatted

SELECT ccl.commission_line_id, ccl.org_id, ccl.commission_header_id, ccl.credited_salesrep_id, cs1.name credited_salesrep_name, cs1.employee_number credited_salesrep_number, ccl.processed_period_id, ccl.processed_date, cq.name plan_element, ccl.payment_factor payment_uplift, ccl.quota_factor quota_uplift, ccl.commission_amount, ccl.commission_rate, ccl.created_during, acc1.period_name pay_period, acc2.period_name accumulation_period, ccl.perf_achieved, ccl.posting_status, ccl.pending_status, lup.meaning trx_status, cs.name payee FROM cn_commission_lines ccl, cn_quotas cq, cn_acc_period_statuses_v acc1, cn_acc_period_statuses_v acc2, cn_srp_payee_assigns cspa, cn_salesreps cs, cn_lookups lup, cn_salesreps cs1 WHERE ccl.quota_id = cq.quota_id(+) and ccl.pay_period_id = acc1.period_id(+) and ccl.processed_period_id = acc2.period_id(+) and ccl.srp_payee_assign_id = cspa.srp_payee_assign_id(+) and lup.lookup_type = 'TRX_STATUS' and ccl.status = lup.lookup_code(+) and ccl.credited_salesrep_id = cs1.salesrep_id(+) and cspa.payee_id = cs.salesrep_id(+) AND ccl.org_id = cq.org_id(+) AND acc1.org_id(+) = ccl.org_id AND ccl.org_id = acc2.org_id(+)

View Text - HTML Formatted

SELECT CCL.COMMISSION_LINE_ID
, CCL.ORG_ID
, CCL.COMMISSION_HEADER_ID
, CCL.CREDITED_SALESREP_ID
, CS1.NAME CREDITED_SALESREP_NAME
, CS1.EMPLOYEE_NUMBER CREDITED_SALESREP_NUMBER
, CCL.PROCESSED_PERIOD_ID
, CCL.PROCESSED_DATE
, CQ.NAME PLAN_ELEMENT
, CCL.PAYMENT_FACTOR PAYMENT_UPLIFT
, CCL.QUOTA_FACTOR QUOTA_UPLIFT
, CCL.COMMISSION_AMOUNT
, CCL.COMMISSION_RATE
, CCL.CREATED_DURING
, ACC1.PERIOD_NAME PAY_PERIOD
, ACC2.PERIOD_NAME ACCUMULATION_PERIOD
, CCL.PERF_ACHIEVED
, CCL.POSTING_STATUS
, CCL.PENDING_STATUS
, LUP.MEANING TRX_STATUS
, CS.NAME PAYEE
FROM CN_COMMISSION_LINES CCL
, CN_QUOTAS CQ
, CN_ACC_PERIOD_STATUSES_V ACC1
, CN_ACC_PERIOD_STATUSES_V ACC2
, CN_SRP_PAYEE_ASSIGNS CSPA
, CN_SALESREPS CS
, CN_LOOKUPS LUP
, CN_SALESREPS CS1
WHERE CCL.QUOTA_ID = CQ.QUOTA_ID(+)
AND CCL.PAY_PERIOD_ID = ACC1.PERIOD_ID(+)
AND CCL.PROCESSED_PERIOD_ID = ACC2.PERIOD_ID(+)
AND CCL.SRP_PAYEE_ASSIGN_ID = CSPA.SRP_PAYEE_ASSIGN_ID(+)
AND LUP.LOOKUP_TYPE = 'TRX_STATUS'
AND CCL.STATUS = LUP.LOOKUP_CODE(+)
AND CCL.CREDITED_SALESREP_ID = CS1.SALESREP_ID(+)
AND CSPA.PAYEE_ID = CS.SALESREP_ID(+)
AND CCL.ORG_ID = CQ.ORG_ID(+)
AND ACC1.ORG_ID(+) = CCL.ORG_ID
AND CCL.ORG_ID = ACC2.ORG_ID(+)