eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_GTAS_TRX_REGISTER dependencies on XLA_DISTRIBUTION_LINKS

Line 1540: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;

1536: l_cohort_select VARCHAR2(100) ;
1537: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
1538: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
1539: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
1540: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;
1544: l_event_type_code xla_ae_headers.event_type_code%TYPE;

Line 1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;

1537: l_fyr_segment_name fv_pya_fiscalyear_segment.application_column_name%TYPE;
1538: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
1539: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
1540: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;
1544: l_event_type_code xla_ae_headers.event_type_code%TYPE;
1545: l_ar_source_id ar_distributions_all.source_id%TYPE;

Line 1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;

1538: l_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
1539: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
1540: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;
1544: l_event_type_code xla_ae_headers.event_type_code%TYPE;
1545: l_ar_source_id ar_distributions_all.source_id%TYPE;
1546: l_ar_source_table ar_distributions_all.source_table%TYPE;

Line 1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;

1539: l_je_from_sla_flag gl_je_headers.je_from_sla_flag%TYPE;
1540: l_source_distribution_id_num_1 xla_distribution_links.source_distribution_id_num_1%TYPE;
1541: l_applied_to_source_id_num_1 xla_distribution_links.applied_to_source_id_num_1%TYPE;
1542: l_applied_to_dist_id_num_1 xla_distribution_links.applied_to_dist_id_num_1%TYPE;
1543: l_source_distribution_type xla_distribution_links.source_distribution_type%TYPE;
1544: l_event_type_code xla_ae_headers.event_type_code%TYPE;
1545: l_ar_source_id ar_distributions_all.source_id%TYPE;
1546: l_ar_source_table ar_distributions_all.source_table%TYPE;
1547: l_ar_source_type ar_distributions_all.source_type%TYPE;

Line 1866: xla_distribution_links xdl,

1862: fv_fund_parameters ffp,
1863: fv_treasury_symbols fts,
1864: xla_ae_lines xal,
1865: xla_ae_headers xah,
1866: xla_distribution_links xdl,
1867: gl_import_references gir
1868: WHERE gjl.ledger_id = :sob_id
1869: AND gjl.status = :status
1870: AND gjl.period_name IN

Line 2466: FROM xla_distribution_links xd

2462: log(l_module,'l_sla_entity_id: '||l_sla_entity_id);
2463:
2464: SELECT alloc_to_dist_id_num_1
2465: INTO l_reference_3 --po_dist_id
2466: FROM xla_distribution_links xd
2467: WHERE xd.source_distribution_id_num_1 = l_source_distribution_id_num_1
2468: AND xd.event_id = l_sla_hdr_event_id
2469: AND ROWNUM = 1;
2470:

Line 5752: xla_distribution_links xd,

5748: xte.transaction_number
5749: FROM gl_import_references gli,
5750: xla_ae_lines xl ,
5751: xla_ae_headers xh ,
5752: xla_distribution_links xd,
5753: xla_transaction_entities xte
5754: WHERE gli.je_batch_id = p_je_batch_id
5755: AND gli.je_header_id = p_je_header_id
5756: AND gli.je_line_num = p_je_line_num