[Home] [Help]
280: SELECT 'C' AS flag FROM DUAL) a,
281: ar_adjustments_all b) doub,
282: psa_mf_trx_dist_all psatd,
283: ra_customer_trx_all trx,
284: ra_cust_trx_line_gl_dist_all ctlgd
285: WHERE adj.rowid >= l_start_rowid
286: AND adj.rowid <= l_end_rowid
287: AND adj.adjustment_id = psaadj.adjustment_id
288: AND doub.adj_id = psaadj.adjustment_id
941: FROM
942: ar_receivable_applications_all app,
943: psa_mf_rct_dist_all a,
944: psa_mf_trx_dist_all psatd,
945: ra_cust_trx_line_gl_dist_all ctlgd,
946: (SELECT 'REC' source_type FROM DUAL UNION
947: SELECT 'EDISC' source_type FROM DUAL UNION
948: SELECT 'UNEDISC' source_type FROM DUAL ) b,
949: (SELECT 'D' side FROM DUAL UNION
1396: , pd.cust_trx_line_gl_dist_id
1397: , ln.accounting_date
1398: , ln.ledger_id
1399: FROM ra_customer_trx_all ct
1400: , ra_cust_trx_line_gl_dist_all ctlgd
1401: , xla_upgrade_dates gud
1402: , xla_transaction_entities_upg ent
1403: , xla_events ev
1404: , xla_ae_headers hdr
1430: AND hdr.ae_header_id = lnk.ae_header_id
1431: AND ln.ae_line_num = lnk.ae_line_num
1432: AND lnk.event_id = ev.event_id
1433: AND lnk.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
1434: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1435: AND nvl(ent.source_id_int_1,-99) = ct.customer_trx_id
1436: AND ev.reference_num_1 = ctlgd.posting_control_id
1437: AND NVL(TRUNC(ctlgd.gl_date), to_date('01-01-1900','DD-MM-YYYY')) = ev.event_date
1438: UNION
1520: , ctlgd.cust_trx_line_gl_dist_id
1521: , ln.accounting_date
1522: , ln.ledger_id
1523: FROM ra_customer_trx_all ct
1524: , ra_cust_trx_line_gl_dist_all ctlgd
1525: , xla_upgrade_dates gud
1526: , xla_transaction_entities_upg ent
1527: , xla_events ev
1528: , xla_ae_headers hdr
1528: , xla_ae_headers hdr
1529: , xla_ae_lines ln
1530: , xla_distribution_links lnk
1531: ,(SELECT /*+ rowid(pdist) use_nl(dist) no_merge */ dist.customer_trx_id
1532: FROM ra_cust_trx_line_gl_dist_all dist,
1533: psa_mf_trx_dist_all pdist,
1534: xla_upgrade_dates xud
1535: WHERE pdist.cust_trx_line_gl_dist_id = dist.cust_trx_line_gl_dist_id
1536: AND trunc(dist.gl_date) between xud.start_date and xud.end_date
1580: AND hdr.ae_header_id = lnk.ae_header_id
1581: AND ln.ae_line_num = lnk.ae_line_num
1582: AND lnk.event_id = ev.event_id
1583: AND lnk.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
1584: AND lnk.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
1585: AND nvl(ent.source_id_int_1,-99) = ct.customer_trx_id
1586: AND ev.reference_num_1 = ctlgd.posting_control_id
1587: AND NVL(TRUNC(ctlgd.gl_date), to_date('01-01-1900','DD-MM-YYYY')) = ev.event_date;
1588:
1882: DAPPLICATION_ID(i) := 222;
1883: DEVENT_ID(i) := ev_EVENT_ID(i);
1884: DAE_HEADER_ID(i) := ln_AE_HEADER_ID(i);
1885: DAE_LINE_NUM(i) := cnt_by_hdr(i) + ln_AE_LINE_NUM(i);
1886: DSOURCE_DISTRIBUTION_TYPE(i) := 'RA_CUST_TRX_LINE_GL_DIST_ALL';
1887: DSOURCE_DISTRIBUTION_ID_NUM_1(i) := pdf_cust_trx_line_gl_dist_id(i);
1888: DTAX_LINE_REF_ID(i) := NULL;
1889: DREF_AE_HEADER_ID(i) := ln_AE_HEADER_ID(i);
1890: DREF_TEMP_LINE_NUM(i) := cnt_by_hdr(i) + ln_AE_LINE_NUM(i);
1968: DAPPLICATION_ID(i) := 222;
1969: DEVENT_ID(i) := ev_EVENT_ID(i);
1970: DAE_HEADER_ID(i) := ln_AE_HEADER_ID(i);
1971: DAE_LINE_NUM(i) := cnt_by_hdr(i) + ln_AE_LINE_NUM(i) + 1;
1972: DSOURCE_DISTRIBUTION_TYPE(i) := 'RA_CUST_TRX_LINE_GL_DIST_ALL';
1973: DSOURCE_DISTRIBUTION_ID_NUM_1(i) := pdf_cust_trx_line_gl_dist_id(i);
1974: DTAX_LINE_REF_ID(i) := NULL;
1975: DREF_AE_HEADER_ID(i) := ln_AE_HEADER_ID(i);
1976: DREF_TEMP_LINE_NUM(i) := cnt_by_hdr(i) + ln_AE_LINE_NUM(i) + 1;