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