[Home] [Help]
160: gld.event_id dist_event_id,
161: distev.event_status_code dist_event_status,
162: distev.event_date dist_event_date,
163: distev.transaction_date dist_ev_trx_date
164: FROM ra_customer_trx trx,
165: ra_cust_trx_line_gl_dist gld,
166: ra_cust_trx_types ctt,
167: xla_transaction_entities_upg xet,
168: xla_events ev,
372: AND account_set_flag = 'N'
373: AND gl_date IS NOT NULL
374: UNION ALL
375: SELECT ra.gl_date gl_date,
376: ra.customer_trx_id trx_id,
377: ra.event_id event_id
378: FROM ra_customer_trx trx,
379: ra_cust_trx_types ctt,
380: ar_receivable_applications ra
374: UNION ALL
375: SELECT ra.gl_date gl_date,
376: ra.customer_trx_id trx_id,
377: ra.event_id event_id
378: FROM ra_customer_trx trx,
379: ra_cust_trx_types ctt,
380: ar_receivable_applications ra
381: WHERE trx.customer_trx_id = p_source_int_id
382: AND ctt.cust_trx_type_id= trx.cust_trx_type_id
381: WHERE trx.customer_trx_id = p_source_int_id
382: AND ctt.cust_trx_type_id= trx.cust_trx_type_id
383: AND ctt.org_id = trx.org_id
384: AND ctt.type = 'CM'
385: AND trx.customer_trx_id = ra.customer_trx_id
386: AND ra.status = 'APP') a;
387:
388: -- Need to insert the CMAPP events
389:
748: p_type IN VARCHAR2)
749: IS
750: SELECT ctlgd.customer_trx_id
751: FROM ra_cust_trx_line_gl_dist_all ctlgd,
752: ra_customer_trx_all trx,
753: ra_cust_trx_types_all tty
754: WHERE ctlgd.gl_date BETWEEN p_start_date AND p_end_date
755: AND ctlgd.posting_control_id = -3
756: AND NVL(p_org_id,ctlgd.org_id) = p_org_id
954: AND ra.posting_control_id = -3
955: AND NVL(p_org_id,ra.org_id) = ra.org_id
956: AND DECODE(p_type,'ALL',p_type,
957: DECODE(ra.cash_receipt_id,NULL,
958: DECODE(ra.customer_trx_id,NULL,NULL,'CMAPP'),
959: 'APP')) = p_type
960: AND NOT EXISTS
961: (SELECT NULL
962: FROM xla_distribution_links lk,