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.JMF_GTA_REPORTS_PKG dependencies on JMF_GTA_TRX_LINES_ALL

Line 1790: jmf_gta_trx_lines_all gta_line

1786: IF (l_gta_taxpayer_id<>l_gt_taxpayer_id)
1787: THEN
1788: --update lines belong to GTA invoice
1789: UPDATE
1790: jmf_gta_trx_lines_all gta_line
1791: SET
1792: gta_line.matched_flag='N'
1793: WHERE gta_line.gta_trx_header_id=
1794: (SELECT

Line 1804: UPDATE jmf_gta_trx_lines_all gt_line

1800: )
1801: AND gta_line.enabled_flag='Y';
1802:
1803: --update lines belong to GT invoice
1804: UPDATE jmf_gta_trx_lines_all gt_line
1805: SET gt_line.matched_flag='N'
1806: WHERE gt_line.gta_trx_header_id=
1807: (SELECT
1808: gt_header.gta_trx_header_id

Line 2030: l_gta_line_number jmf_gta_trx_lines_all.line_number%TYPE;

2026: l_ar_unit_price_disp VARCHAR2(50);
2027: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;
2028: l_ar_tax_reg_number zx_registrations.registration_number%TYPE;
2029: l_gta_trx_number jmf_gta_trx_headers_all.gta_trx_number%TYPE;
2030: l_gta_line_number jmf_gta_trx_lines_all.line_number%TYPE;
2031: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;
2032: l_gta_line_amount NUMBER;
2033: l_gta_vat_line_tax NUMBER;
2034: l_gta_vat_tax_rate NUMBER;

Line 2045: l_matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE;

2041: l_gta_line_taxamount_sum NUMBER;
2042: l_gta_line_taxamount_sum_disp VARCHAR2(50);
2043: l_gta_line_quantity_sum NUMBER;
2044: l_gta_tax_reg_number jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
2045: l_matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE;
2046: l_matched_flag_total jmf_gta_trx_lines_all.matched_flag%TYPE;
2047: l_goods_description_attr fnd_lookup_values.meaning%TYPE;
2048: l_line_amount_attr fnd_lookup_values.meaning%TYPE;
2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;

Line 2046: l_matched_flag_total jmf_gta_trx_lines_all.matched_flag%TYPE;

2042: l_gta_line_taxamount_sum_disp VARCHAR2(50);
2043: l_gta_line_quantity_sum NUMBER;
2044: l_gta_tax_reg_number jmf_gta_trx_headers_all.tp_tax_registration_number%TYPE;
2045: l_matched_flag jmf_gta_trx_lines_all.matched_flag%TYPE;
2046: l_matched_flag_total jmf_gta_trx_lines_all.matched_flag%TYPE;
2047: l_goods_description_attr fnd_lookup_values.meaning%TYPE;
2048: l_line_amount_attr fnd_lookup_values.meaning%TYPE;
2049: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2050: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;

Line 2111: ,jmf_gta_trx_lines_all jgtl

2107: ,jgtl.uom
2108: ,jgtl.matched_flag
2109: FROM
2110: jmf_gta_trx_headers jgth
2111: ,jmf_gta_trx_lines_all jgtl
2112: WHERE jgth.ra_trx_id=l_ar_header_id
2113: AND jgth.source='AR'
2114: AND jgth.status='COMPLETED'
2115: AND jgth.latest_version_flag='Y'

Line 2126: ,jmf_gta_trx_lines_all jgtl

2122: SELECT
2123: COUNT(*)
2124: FROM
2125: jmf_gta_trx_headers jgth
2126: ,jmf_gta_trx_lines_all jgtl
2127: WHERE jgth.ra_trx_id=l_ar_header_id
2128: AND jgth.source='AR'
2129: AND jgth.status='COMPLETED'
2130: AND jgth.latest_version_flag='Y'

Line 2153: ,jmf_gta_trx_lines_all jgtl

2149: jgth.gta_trx_number
2150: ,jgtl.line_number
2151: FROM
2152: jmf_gta_trx_headers jgth
2153: ,jmf_gta_trx_lines_all jgtl
2154: WHERE jgth.ra_trx_id=l_ar_header_id
2155: AND jgth.source='AR'
2156: AND jgth.status='COMPLETED'
2157: AND jgth.latest_version_flag='Y'

Line 2206: ,jmf_gta_trx_lines_all jgtl

2202: AND NOT EXISTS (SELECT
2203: jgtl.ar_trx_line_id
2204: FROM
2205: jmf_gta_trx_headers jgth
2206: ,jmf_gta_trx_lines_all jgtl
2207: WHERE jgth.ra_trx_id=l_ar_header_id
2208: AND jgth.source='AR'
2209: AND jgtl.gta_trx_header_id=jgth.gta_trx_header_id
2210: AND jgtl.ar_trx_line_id=rctl.customer_trx_line_id