VIEW: APPS.CN_PMT_PLAN_ASGN_V

Source

View Text - Preformatted

SELECT spp.SRP_PMT_PLAN_ID , spp.SALESREP_ID , spp.PMT_PLAN_ID , pp.NAME pmt_plan_name , pp.CREDIT_TYPE_ID , spp.START_DATE , spp.END_DATE , spp.MINIMUM_AMOUNT , spp.MAXIMUM_AMOUNT , spp.MAX_RECOVERY_AMOUNT , spp.object_version_number , pp.RECOVERABLE_INTERVAL_TYPE_ID , pp.PAY_AGAINST_COMMISSION , pp.MIN_REC_FLAG , pp.MAX_REC_FLAG , pp.RULES_PKG_NAME , pp.START_DATE start_date_pmt_plans , pp.END_DATE end_date_pmt_plans , pp.pay_interval_type_id interval_type_id , pp.payment_group_code, spp.lock_flag, spp.org_id from cn_srp_pmt_plans spp, cn_pmt_plans_all pp, cn_credit_types_all crt, cn_interval_types_all intr WHERE spp.pmt_plan_id = pp.pmt_plan_id and spp.credit_type_id = crt.credit_type_id and spp.org_id = crt.org_id and pp.PAY_INTERVAL_TYPE_ID = intr.INTERVAL_TYPE_ID and spp.org_id = intr.org_id

View Text - HTML Formatted

SELECT SPP.SRP_PMT_PLAN_ID
, SPP.SALESREP_ID
, SPP.PMT_PLAN_ID
, PP.NAME PMT_PLAN_NAME
, PP.CREDIT_TYPE_ID
, SPP.START_DATE
, SPP.END_DATE
, SPP.MINIMUM_AMOUNT
, SPP.MAXIMUM_AMOUNT
, SPP.MAX_RECOVERY_AMOUNT
, SPP.OBJECT_VERSION_NUMBER
, PP.RECOVERABLE_INTERVAL_TYPE_ID
, PP.PAY_AGAINST_COMMISSION
, PP.MIN_REC_FLAG
, PP.MAX_REC_FLAG
, PP.RULES_PKG_NAME
, PP.START_DATE START_DATE_PMT_PLANS
, PP.END_DATE END_DATE_PMT_PLANS
, PP.PAY_INTERVAL_TYPE_ID INTERVAL_TYPE_ID
, PP.PAYMENT_GROUP_CODE
, SPP.LOCK_FLAG
, SPP.ORG_ID
FROM CN_SRP_PMT_PLANS SPP
, CN_PMT_PLANS_ALL PP
, CN_CREDIT_TYPES_ALL CRT
, CN_INTERVAL_TYPES_ALL INTR
WHERE SPP.PMT_PLAN_ID = PP.PMT_PLAN_ID
AND SPP.CREDIT_TYPE_ID = CRT.CREDIT_TYPE_ID
AND SPP.ORG_ID = CRT.ORG_ID
AND PP.PAY_INTERVAL_TYPE_ID = INTR.INTERVAL_TYPE_ID
AND SPP.ORG_ID = INTR.ORG_ID