APPS.JMF_GTA_REPORTS_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 2016: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

2012: :=p_org_id;
2013: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
2014: :=p_ar_header_id;
2015: l_has_difference BOOLEAN;
2016: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2017: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;
2018: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2019: l_ar_line_amount NUMBER;
2020: l_ar_line_amount_disp VARCHAR2(50);

Line 2017: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;

2013: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE
2014: :=p_ar_header_id;
2015: l_has_difference BOOLEAN;
2016: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2017: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;
2018: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2019: l_ar_line_amount NUMBER;
2020: l_ar_line_amount_disp VARCHAR2(50);
2021: l_ar_vat_line_tax NUMBER;

Line 2018: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;

2014: :=p_ar_header_id;
2015: l_has_difference BOOLEAN;
2016: l_ar_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2017: l_ar_line_number ra_customer_trx_lines_all.line_number%TYPE;
2018: l_ar_goods_description ra_customer_trx_lines_all.description%TYPE;
2019: l_ar_line_amount NUMBER;
2020: l_ar_line_amount_disp VARCHAR2(50);
2021: l_ar_vat_line_tax NUMBER;
2022: l_ar_vat_line_tax_disp VARCHAR2(50);

Line 2027: l_ar_uom ra_customer_trx_lines_all.uom_code%TYPE;

2023: l_ar_vat_tax_rate NUMBER;
2024: l_ar_quantity NUMBER;
2025: l_ar_unit_price NUMBER;
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;

Line 2031: l_gta_goods_description ra_customer_trx_lines_all.description%TYPE;

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;
2035: l_gta_quantity NUMBER;

Line 2038: l_gta_uom ra_customer_trx_lines_all.uom_code%TYPE;

2034: l_gta_vat_tax_rate NUMBER;
2035: l_gta_quantity NUMBER;
2036: l_gta_unit_price NUMBER;
2037: l_gta_unit_price_disp VARCHAR2(50);
2038: l_gta_uom ra_customer_trx_lines_all.uom_code%TYPE;
2039: l_gta_line_amount_sum NUMBER;
2040: l_gta_line_amount_sum_disp VARCHAR2(50);
2041: l_gta_line_taxamount_sum NUMBER;
2042: l_gta_line_taxamount_sum_disp VARCHAR2(50);

Line 2092: ra_customer_trx_lines rctl

2088: ,rctl.quantity_invoiced quantity
2089: ,rctl.unit_selling_price unit_price
2090: ,rctl.uom_code uom
2091: FROM
2092: ra_customer_trx_lines rctl
2093: WHERE rctl.customer_trx_id=l_ar_header_id
2094: AND rctl.line_type='LINE';
2095:
2096: CURSOR c_gta_lines IS

Line 2162: ra_customer_trx_lines rctl

2158: AND jgtl.gta_trx_header_id=jgth.gta_trx_header_id
2159: AND NOT EXISTS (SELECT
2160: rctl.customer_trx_line_id
2161: FROM
2162: ra_customer_trx_lines rctl
2163: WHERE rctl.customer_trx_id=l_ar_header_id
2164: AND rctl.customer_trx_line_id=jgtl.ar_trx_line_id
2165: );
2166:

Line 2184: ra_customer_trx_lines rctl

2180: SELECT
2181: rctl.customer_trx_line_id ar_line_id
2182: ,rctl.line_number ar_line_num
2183: FROM
2184: ra_customer_trx_lines rctl
2185: WHERE rctl.customer_trx_id=l_ar_header_id
2186: AND EXISTS (SELECT
2187: zl.trx_line_id
2188: FROM