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.AR_GTA_REPORTS_PKG dependencies on AR_GTA_TRX_LINES_ALL

Line 1884: ar_gta_trx_lines_all gta_line

1880: IF ((l_gta_taxpayer_id<>l_gt_taxpayer_id)AND l_gta_status='COMPLETED')--Yao Zhang add for bug#8765631
1881: THEN
1882: --update lines belong to GTA invoice
1883: UPDATE
1884: ar_gta_trx_lines_all gta_line
1885: SET
1886: gta_line.matched_flag='N'
1887: WHERE gta_line.gta_trx_header_id=
1888: (SELECT

Line 1898: UPDATE ar_gta_trx_lines_all gt_line

1894: )
1895: AND gta_line.enabled_flag='Y';
1896:
1897: --update lines belong to GT invoice
1898: UPDATE ar_gta_trx_lines_all gt_line
1899: SET gt_line.matched_flag='N'
1900: WHERE gt_line.gta_trx_header_id=
1901: (SELECT
1902: gt_header.gta_trx_header_id

Line 2133: l_gta_line_number ar_gta_trx_lines_all.line_number%TYPE;

2129: l_ar_unit_price_disp VARCHAR2(50);
2130: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;
2131: l_ar_tax_reg_number zx_registrations.registration_number%TYPE;
2132: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
2133: l_gta_line_number ar_gta_trx_lines_all.line_number%TYPE;
2134: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;
2135: l_gta_line_amount NUMBER;
2136: l_gta_vat_line_tax NUMBER;
2137: l_gta_vat_tax_rate NUMBER;

Line 2148: l_matched_flag ar_gta_trx_lines_all.matched_flag%TYPE;

2144: l_gta_line_taxamount_sum NUMBER;
2145: l_gta_line_taxamount_sum_disp VARCHAR2(50);
2146: l_gta_line_quantity_sum NUMBER;
2147: l_gta_tax_reg_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
2148: l_matched_flag ar_gta_trx_lines_all.matched_flag%TYPE;
2149: l_matched_flag_total ar_gta_trx_lines_all.matched_flag%TYPE;
2150: l_goods_description_attr fnd_lookup_values.meaning%TYPE;
2151: l_line_amount_attr fnd_lookup_values.meaning%TYPE;
2152: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;

Line 2149: l_matched_flag_total ar_gta_trx_lines_all.matched_flag%TYPE;

2145: l_gta_line_taxamount_sum_disp VARCHAR2(50);
2146: l_gta_line_quantity_sum NUMBER;
2147: l_gta_tax_reg_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
2148: l_matched_flag ar_gta_trx_lines_all.matched_flag%TYPE;
2149: l_matched_flag_total ar_gta_trx_lines_all.matched_flag%TYPE;
2150: l_goods_description_attr fnd_lookup_values.meaning%TYPE;
2151: l_line_amount_attr fnd_lookup_values.meaning%TYPE;
2152: l_vat_line_tax_attr fnd_lookup_values.meaning%TYPE;
2153: l_vat_tax_rate_attr fnd_lookup_values.meaning%TYPE;

Line 2190: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;

2186: l_discount_adjustment_id ra_customer_trx_lines_all.interface_line_attribute11%TYPE;
2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2190: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2191: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2192: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2193:
2194:

Line 2191: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;

2187: l_price_adjustment_id ra_customer_trx_lines_all.interface_line_attribute1%TYPE;
2188: l_ar_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2189: l_adjustment_type OE_PRICE_ADJUSTMENTS.list_line_type_code%TYPE;
2190: l_discount_amount ar_gta_trx_lines_all.discount_amount%TYPE;
2191: l_discount_tax_amount ar_gta_trx_lines_all.discount_tax_amount%TYPE;
2192: l_discount_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2193:
2194:
2195: CURSOR c_ar_lines IS

Line 2230: ,ar_gta_trx_lines_all jgtl

2226: ,jgtl.uom
2227: ,jgtl.matched_flag
2228: FROM
2229: ar_gta_trx_headers jgth
2230: ,ar_gta_trx_lines_all jgtl
2231: WHERE jgth.ra_trx_id=l_ar_header_id
2232: AND jgth.source='AR'
2233: AND (jgth.status='COMPLETED' OR jgth.status='CONSOLIDATED')
2234: AND jgth.latest_version_flag='Y'

Line 2245: ,ar_gta_trx_lines_all jgtl

2241: SELECT
2242: COUNT(*)
2243: FROM
2244: ar_gta_trx_headers jgth
2245: ,ar_gta_trx_lines_all jgtl
2246: WHERE jgth.ra_trx_id=l_ar_header_id
2247: AND jgth.source='AR'
2248: AND jgth.status='COMPLETED'
2249: AND jgth.latest_version_flag='Y'

Line 2268: ,ar_gta_trx_lines_all jgtl

2264: jgth.gta_trx_number
2265: ,jgtl.line_number
2266: FROM
2267: ar_gta_trx_headers jgth
2268: ,ar_gta_trx_lines_all jgtl
2269: WHERE jgth.ra_trx_id=l_ar_header_id
2270: AND jgth.source='AR'
2271: AND jgth.status='COMPLETED'
2272: AND jgth.latest_version_flag='Y'

Line 2327: ,ar_gta_trx_lines_all jgtl

2323: AND NOT EXISTS (SELECT
2324: jgtl.ar_trx_line_id
2325: FROM
2326: ar_gta_trx_headers jgth
2327: ,ar_gta_trx_lines_all jgtl
2328: WHERE jgth.ra_trx_id=l_ar_header_id
2329: AND jgth.source='AR'
2330: AND jgtl.gta_trx_header_id=jgth.gta_trx_header_id
2331: AND jgtl.ar_trx_line_id=rctl.customer_trx_line_id