VIEW: APPS.CN_POSTING_DETAILS_V

Source

View Text - Preformatted

SELECT pd.posting_detail_id posting_detail_id, pb.name posting_batch, cn_api.get_lkup_meaning(pd.posting_type, 'POSTING_TYPE') posting_type, pd.payee_salesrep_id payee_salesrep_id, srp1.name payee_salesrep, pd.credited_salesrep_id credited_salesrep_id, srp2.name credited_salesrep, role.name sales_role, ct.name credit_type, pd.pay_period_id pay_period_id, ps.period_name period_name, cn_api.get_lkup_meaning(pd.trx_type, 'TRX TYPES') transaction_type, cn_api.get_lkup_meaning(pd.incentive_type_code, 'INCENTIVE_TYPE') incentive_type, pd.processed_date processed_date, nvl(pd.amount,0) amount, nvl(pd.payment_amount,0) payment_amount, cn_api.get_lkup_meaning(pd.hold_flag, 'YES_NO') hold_flag, cn_api.get_lkup_meaning(pd.paid_flag, 'YES_NO') paid_flag, cp.name comp_plan, q.name plan_element, pay.name payrun, pd.expense_ccid expense_ccid, pd.liability_ccid liability_ccid, pd.commission_header_id commission_header_id, pd.commission_line_id commission_line_id, cn_api.get_lkup_meaning(pd.status, 'LOAD_STATUS') loading_status, pd.loaded_date loaded_date, pd.attribute_category, pd.attribute1, pd.attribute2, pd.attribute3, pd.attribute4, pd.attribute5, pd.attribute6, pd.attribute7, pd.attribute8, pd.attribute9, pd.attribute10, pd.attribute11, pd.attribute12, pd.attribute13, pd.attribute14, pd.attribute15 from cn_posting_details pd, cn_posting_batches pb, cn_salesreps srp1, cn_roles role, cn_credit_types ct, cn_srp_plan_assigns spa, cn_comp_plans cp, cn_quotas q, cn_salesreps srp2, cn_payruns pay, cn_period_statuses ps WHERE pd.posting_batch_id = pb.posting_batch_id and pd.payee_salesrep_id = srp1.salesrep_id and pd.role_id = role.role_id and pd.credit_type_id = ct.credit_type_id and pd.srp_plan_assign_id = spa.srp_plan_assign_id (+) and spa.comp_plan_id = cp.comp_plan_id (+) and pd.quota_id = q.quota_id (+) and pd.credited_salesrep_id = srp2.salesrep_id and pd.payrun_id = pay.payrun_id (+) and pd.pay_period_id = ps.period_id

View Text - HTML Formatted

SELECT PD.POSTING_DETAIL_ID POSTING_DETAIL_ID
, PB.NAME POSTING_BATCH
, CN_API.GET_LKUP_MEANING(PD.POSTING_TYPE
, 'POSTING_TYPE') POSTING_TYPE
, PD.PAYEE_SALESREP_ID PAYEE_SALESREP_ID
, SRP1.NAME PAYEE_SALESREP
, PD.CREDITED_SALESREP_ID CREDITED_SALESREP_ID
, SRP2.NAME CREDITED_SALESREP
, ROLE.NAME SALES_ROLE
, CT.NAME CREDIT_TYPE
, PD.PAY_PERIOD_ID PAY_PERIOD_ID
, PS.PERIOD_NAME PERIOD_NAME
, CN_API.GET_LKUP_MEANING(PD.TRX_TYPE
, 'TRX TYPES') TRANSACTION_TYPE
, CN_API.GET_LKUP_MEANING(PD.INCENTIVE_TYPE_CODE
, 'INCENTIVE_TYPE') INCENTIVE_TYPE
, PD.PROCESSED_DATE PROCESSED_DATE
, NVL(PD.AMOUNT
, 0) AMOUNT
, NVL(PD.PAYMENT_AMOUNT
, 0) PAYMENT_AMOUNT
, CN_API.GET_LKUP_MEANING(PD.HOLD_FLAG
, 'YES_NO') HOLD_FLAG
, CN_API.GET_LKUP_MEANING(PD.PAID_FLAG
, 'YES_NO') PAID_FLAG
, CP.NAME COMP_PLAN
, Q.NAME PLAN_ELEMENT
, PAY.NAME PAYRUN
, PD.EXPENSE_CCID EXPENSE_CCID
, PD.LIABILITY_CCID LIABILITY_CCID
, PD.COMMISSION_HEADER_ID COMMISSION_HEADER_ID
, PD.COMMISSION_LINE_ID COMMISSION_LINE_ID
, CN_API.GET_LKUP_MEANING(PD.STATUS
, 'LOAD_STATUS') LOADING_STATUS
, PD.LOADED_DATE LOADED_DATE
, PD.ATTRIBUTE_CATEGORY
, PD.ATTRIBUTE1
, PD.ATTRIBUTE2
, PD.ATTRIBUTE3
, PD.ATTRIBUTE4
, PD.ATTRIBUTE5
, PD.ATTRIBUTE6
, PD.ATTRIBUTE7
, PD.ATTRIBUTE8
, PD.ATTRIBUTE9
, PD.ATTRIBUTE10
, PD.ATTRIBUTE11
, PD.ATTRIBUTE12
, PD.ATTRIBUTE13
, PD.ATTRIBUTE14
, PD.ATTRIBUTE15
FROM CN_POSTING_DETAILS PD
, CN_POSTING_BATCHES PB
, CN_SALESREPS SRP1
, CN_ROLES ROLE
, CN_CREDIT_TYPES CT
, CN_SRP_PLAN_ASSIGNS SPA
, CN_COMP_PLANS CP
, CN_QUOTAS Q
, CN_SALESREPS SRP2
, CN_PAYRUNS PAY
, CN_PERIOD_STATUSES PS
WHERE PD.POSTING_BATCH_ID = PB.POSTING_BATCH_ID
AND PD.PAYEE_SALESREP_ID = SRP1.SALESREP_ID
AND PD.ROLE_ID = ROLE.ROLE_ID
AND PD.CREDIT_TYPE_ID = CT.CREDIT_TYPE_ID
AND PD.SRP_PLAN_ASSIGN_ID = SPA.SRP_PLAN_ASSIGN_ID (+)
AND SPA.COMP_PLAN_ID = CP.COMP_PLAN_ID (+)
AND PD.QUOTA_ID = Q.QUOTA_ID (+)
AND PD.CREDITED_SALESREP_ID = SRP2.SALESREP_ID
AND PD.PAYRUN_ID = PAY.PAYRUN_ID (+)
AND PD.PAY_PERIOD_ID = PS.PERIOD_ID