DBA Data[Home] [Help]

APPS.JMF_GTA_REPORTS_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

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);