VIEW: APPS.CN_SUBLEDGER_PAYMENT

Source

View Text - Preformatted

SELECT pw.salesrep_id, pw.role_id, pw.credit_type_id, pr.payrun_id, pr.name, pr.pay_date, pr.pay_period_id, ps.period_name, pr.accounting_period_id, ps_acct.start_date, ps_acct.end_date, pw.payment_worksheet_id, (NVL(pw.pmt_amount_calc,0) + NVL(pw.pmt_amount_adj_rec,0) + NVL(pw.pmt_amount_adj_nrec,0) + NVL(pw.pmt_amount_adj,0) + NVL(pw.pmt_amount_recovery,0)) gross_pay, pw.org_id FROM cn_payruns pr, cn_payment_worksheets pw, cn_period_statuses ps, cn_period_statuses ps_acct WHERE pr.payrun_id = pw.payrun_id AND pr.status = 'PAID' AND pr.pay_period_id = ps.period_id AND pr.accounting_period_id = ps_acct.period_id AND pw.quota_id is null AND ps.org_id = pw.org_id AND ps_acct.org_id = pw.org_id

View Text - HTML Formatted

SELECT PW.SALESREP_ID
, PW.ROLE_ID
, PW.CREDIT_TYPE_ID
, PR.PAYRUN_ID
, PR.NAME
, PR.PAY_DATE
, PR.PAY_PERIOD_ID
, PS.PERIOD_NAME
, PR.ACCOUNTING_PERIOD_ID
, PS_ACCT.START_DATE
, PS_ACCT.END_DATE
, PW.PAYMENT_WORKSHEET_ID
, (NVL(PW.PMT_AMOUNT_CALC
, 0) + NVL(PW.PMT_AMOUNT_ADJ_REC
, 0) + NVL(PW.PMT_AMOUNT_ADJ_NREC
, 0) + NVL(PW.PMT_AMOUNT_ADJ
, 0) + NVL(PW.PMT_AMOUNT_RECOVERY
, 0)) GROSS_PAY
, PW.ORG_ID
FROM CN_PAYRUNS PR
, CN_PAYMENT_WORKSHEETS PW
, CN_PERIOD_STATUSES PS
, CN_PERIOD_STATUSES PS_ACCT
WHERE PR.PAYRUN_ID = PW.PAYRUN_ID
AND PR.STATUS = 'PAID'
AND PR.PAY_PERIOD_ID = PS.PERIOD_ID
AND PR.ACCOUNTING_PERIOD_ID = PS_ACCT.PERIOD_ID
AND PW.QUOTA_ID IS NULL
AND PS.ORG_ID = PW.ORG_ID
AND PS_ACCT.ORG_ID = PW.ORG_ID