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_HEADERS_ALL

Line 142: AR_Gta_Trx_Headers_All Gt

138: COUNT(*)
139: INTO
140: l_count
141: FROM
142: AR_Gta_Trx_Headers_All Gt
143: WHERE Gt.Ra_Trx_Id = p_ar_trx_header_id
144: AND Source='GT'
145: AND Status='COMPLETED'
146: AND (Gt_Invoice_Number NOT BETWEEN p_Gt_Inv_Num_From

Line 440: ar_gta_trx_headers_all

436: COUNT(*)
437: INTO
438: l_count
439: FROM
440: ar_gta_trx_headers_all
441: WHERE Ra_Trx_Id=P_Ar_Trx_Header_Id
442: AND Source='GT'
443: AND Status='COMPLETED'
444: AND Gt_Invoice_Number BETWEEN p_Gt_Inv_Num_From

Line 467: AR_Gta_Trx_Headers_all

463: ))))
464: INTO
465: l_Ret_Xmlelement
466: FROM
467: AR_Gta_Trx_Headers_all
468: WHERE Ra_Trx_Id=P_Ar_Trx_Header_Id
469: AND Source='GT'
470: AND Status='COMPLETED'
471: AND Gt_Invoice_Number BETWEEN p_Gt_Inv_Num_From

Line 583: AR_Gta_Trx_Headers_All Gt

579: CURSOR C_Trx_Ids IS
580: SELECT
581: DISTINCT Gt.Ra_Trx_Id
582: FROM
583: AR_Gta_Trx_Headers_All Gt
584: ,Ra_Customer_Trx_All Ar
585: WHERE Gt.Ra_Trx_Id=Ar.Customer_Trx_Id
586: AND Gt.Org_Id=P_Org_Id
587: AND Gt.Fp_Tax_Registration_Number=NVL(p_fp_tax_reg_num

Line 868: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;

864: l_ar_customer_address_phone VARCHAR2(4000);
865: l_ar_customer_phone hz_contact_points.phone_number%TYPE;
866: l_gta_amount NUMBER;
867: l_gta_taxamount NUMBER;
868: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
869: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
870: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
871: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
872: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;

Line 869: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;

865: l_ar_customer_phone hz_contact_points.phone_number%TYPE;
866: l_gta_amount NUMBER;
867: l_gta_taxamount NUMBER;
868: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
869: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
870: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
871: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
872: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
873: l_gta_amount_sum NUMBER;

Line 870: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;

866: l_gta_amount NUMBER;
867: l_gta_taxamount NUMBER;
868: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
869: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
870: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
871: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
872: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
873: l_gta_amount_sum NUMBER;
874: l_gta_amount_sum_disp VARCHAR2(50);

Line 871: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;

867: l_gta_taxamount NUMBER;
868: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
869: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
870: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
871: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
872: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
873: l_gta_amount_sum NUMBER;
874: l_gta_amount_sum_disp VARCHAR2(50);
875: l_gta_taxamount_sum NUMBER;

Line 872: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;

868: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
869: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
870: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
871: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
872: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
873: l_gta_amount_sum NUMBER;
874: l_gta_amount_sum_disp VARCHAR2(50);
875: l_gta_taxamount_sum NUMBER;
876: l_gta_taxamount_sum_disp VARCHAR2(50);

Line 880: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;

876: l_gta_taxamount_sum_disp VARCHAR2(50);
877: l_gta_trx_number_con VARCHAR2(4000);
878: l_gt_amount NUMBER;
879: l_gt_taxamount NUMBER;
880: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
881: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
882: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
883: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
884: l_gt_amount_sum NUMBER;

Line 881: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;

877: l_gta_trx_number_con VARCHAR2(4000);
878: l_gt_amount NUMBER;
879: l_gt_taxamount NUMBER;
880: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
881: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
882: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
883: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
884: l_gt_amount_sum NUMBER;
885: l_gt_amount_sum_disp VARCHAR2(50);

Line 882: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;

878: l_gt_amount NUMBER;
879: l_gt_taxamount NUMBER;
880: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
881: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
882: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
883: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
884: l_gt_amount_sum NUMBER;
885: l_gt_amount_sum_disp VARCHAR2(50);
886: l_gt_taxamount_sum NUMBER;

Line 883: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;

879: l_gt_taxamount NUMBER;
880: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
881: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
882: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
883: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
884: l_gt_amount_sum NUMBER;
885: l_gt_amount_sum_disp VARCHAR2(50);
886: l_gt_taxamount_sum NUMBER;
887: l_gt_taxamount_sum_disp VARCHAR2(50);

Line 888: l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;

884: l_gt_amount_sum NUMBER;
885: l_gt_amount_sum_disp VARCHAR2(50);
886: l_gt_taxamount_sum NUMBER;
887: l_gt_taxamount_sum_disp VARCHAR2(50);
888: l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;
889: l_gt_invoice_number_con VARCHAR2(4000);
890: l_gta_header_id NUMBER;
891: l_ar_mask_bank VARCHAR2(50);
892: l_amount_discrepancy VARCHAR2(40);

Line 904: l_gta_customer_bank_account_m ar_gta_trx_headers_all.bank_account_name_number%TYPE;

900: l_address_phone_attr fnd_lookup_values.meaning%TYPE;
901: l_taxpayer_id_attr fnd_lookup_values.meaning%TYPE;
902:
903: l_ar_customer_bank_account_m VARCHAR2(360);
904: l_gta_customer_bank_account_m ar_gta_trx_headers_all.bank_account_name_number%TYPE;
905: l_gt_customer_bank_account_m ar_gta_trx_headers_all.bank_account_name_number%TYPE;
906: l_ar_bank_name ce_bank_branches_v.bank_name%TYPE;
907: l_ar_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
908: l_ar_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

Line 905: l_gt_customer_bank_account_m ar_gta_trx_headers_all.bank_account_name_number%TYPE;

901: l_taxpayer_id_attr fnd_lookup_values.meaning%TYPE;
902:
903: l_ar_customer_bank_account_m VARCHAR2(360);
904: l_gta_customer_bank_account_m ar_gta_trx_headers_all.bank_account_name_number%TYPE;
905: l_gt_customer_bank_account_m ar_gta_trx_headers_all.bank_account_name_number%TYPE;
906: l_ar_bank_name ce_bank_branches_v.bank_name%TYPE;
907: l_ar_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
908: l_ar_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
909: l_ar_bank_account_name ce_bank_accounts.bank_account_name%TYPE;

Line 1891: ar_gta_trx_headers_all gta_header

1887: WHERE gta_line.gta_trx_header_id=
1888: (SELECT
1889: gta_header.gta_trx_header_id
1890: FROM
1891: ar_gta_trx_headers_all gta_header
1892: WHERE gta_header.source='AR'
1893: AND gta_header.gta_trx_number=l_gta_trx_number
1894: )
1895: AND gta_line.enabled_flag='Y';

Line 1904: ar_gta_trx_headers_all gt_header

1900: WHERE gt_line.gta_trx_header_id=
1901: (SELECT
1902: gt_header.gta_trx_header_id
1903: FROM
1904: ar_gta_trx_headers_all gt_header
1905: WHERE gt_header.source='GT'
1906: AND gt_header.gta_trx_number=l_gta_trx_number
1907: );
1908: END IF; --(l_gta_taxpayer_id<>l_gt_taxpayer_id)

Line 2132: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;

2128: l_ar_unit_price NUMBER;
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;

Line 2147: l_gta_tax_reg_number ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;

2143: l_gta_line_amount_sum_disp VARCHAR2(50);
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;

Line 2162: --l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;

2158: l_uom_attr fnd_lookup_values.meaning%TYPE;
2159: l_gt_value VARCHAR2(500);
2160:
2161: --Change length of the variable l_gt_invoice_number to 4000 to fix bug 6132187
2162: --l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;
2163: l_gt_invoice_number VARCHAR2(4000);
2164: --------------------------------------------------
2165:
2166: l_gta_trx_number_con VARCHAR2(4000);

Line 2258: ar_gta_trx_headers_all jgth

2254: CURSOR c_gt_invoice_number IS
2255: SELECT
2256: jgth.gt_invoice_number
2257: FROM
2258: ar_gta_trx_headers_all jgth
2259: WHERE jgth.source='GT'
2260: AND jgth.gta_trx_number=l_gta_trx_number;
2261:
2262: CURSOR c_missing_ar_line IS

Line 3839: l_gta_batch_num_from ar_gta_trx_headers_all.gta_batch_number%TYPE

3835: l_primary_sales_name ra_salesreps_all.name%TYPE;
3836: l_customer_id hz_cust_accounts.cust_account_id%TYPE
3837: :=p_cust_name_id;
3838: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3839: l_gta_batch_num_from ar_gta_trx_headers_all.gta_batch_number%TYPE
3840: :=p_gta_batch_num_from;
3841: l_gta_batch_num_to ar_gta_trx_headers_all.gta_batch_number%TYPE
3842: :=p_gta_batch_num_to;
3843: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;

Line 3841: l_gta_batch_num_to ar_gta_trx_headers_all.gta_batch_number%TYPE

3837: :=p_cust_name_id;
3838: l_ar_header_id ra_customer_trx_all.customer_trx_id%TYPE;
3839: l_gta_batch_num_from ar_gta_trx_headers_all.gta_batch_number%TYPE
3840: :=p_gta_batch_num_from;
3841: l_gta_batch_num_to ar_gta_trx_headers_all.gta_batch_number%TYPE
3842: :=p_gta_batch_num_to;
3843: l_ar_transaction_type ra_cust_trx_types_all.name%TYPE;
3844: l_cust_num_from hz_cust_accounts.account_number%TYPE
3845: :=p_cust_num_from;

Line 4707: l_gta_consolidation_flag ar_gta_trx_headers_all.consolidation_flag%TYPE;

4703: l_api_name VARCHAR2(50)
4704: :='Generate_Discrepancy_Rep';
4705: l_dbg_msg VARCHAR2(100);
4706:
4707: l_gta_consolidation_flag ar_gta_trx_headers_all.consolidation_flag%TYPE;
4708:
4709:
4710: CURSOR c_trx_header IS
4711: SELECT DISTINCT

Line 5286: l_consol_trx_num_from AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE

5282: i NUMBER;
5283: l_consolidated_rows NUMBER;
5284: l_no_data_flag VARCHAR2(1):='N';
5285:
5286: l_consol_trx_num_from AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE
5287: := p_consol_trx_num_from;
5288: l_consol_trx_num_to AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE
5289: := p_consol_trx_num_to;
5290: l_customer_num_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE

Line 5288: l_consol_trx_num_to AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE

5284: l_no_data_flag VARCHAR2(1):='N';
5285:
5286: l_consol_trx_num_from AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE
5287: := p_consol_trx_num_from;
5288: l_consol_trx_num_to AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE
5289: := p_consol_trx_num_to;
5290: l_customer_num_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE
5291: := p_customer_num_from;
5292: l_customer_num_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE

Line 5290: l_customer_num_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE

5286: l_consol_trx_num_from AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE
5287: := p_consol_trx_num_from;
5288: l_consol_trx_num_to AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE
5289: := p_consol_trx_num_to;
5290: l_customer_num_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE
5291: := p_customer_num_from;
5292: l_customer_num_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE
5293: := p_customer_num_to;
5294: l_customer_name_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE

Line 5292: l_customer_num_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE

5288: l_consol_trx_num_to AR_Gta_Trx_Headers_All.CONSOLIDATION_TRX_NUM%TYPE
5289: := p_consol_trx_num_to;
5290: l_customer_num_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE
5291: := p_customer_num_from;
5292: l_customer_num_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE
5293: := p_customer_num_to;
5294: l_customer_name_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE
5295: := p_customer_name_from;
5296: l_customer_name_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE

Line 5294: l_customer_name_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE

5290: l_customer_num_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE
5291: := p_customer_num_from;
5292: l_customer_num_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE
5293: := p_customer_num_to;
5294: l_customer_name_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE
5295: := p_customer_name_from;
5296: l_customer_name_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE
5297: := p_customer_name_to;
5298: l_invoice_type AR_Gta_Trx_Headers_All.INVOICE_TYPE%TYPE

Line 5296: l_customer_name_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE

5292: l_customer_num_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NUMBER%TYPE
5293: := p_customer_num_to;
5294: l_customer_name_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE
5295: := p_customer_name_from;
5296: l_customer_name_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE
5297: := p_customer_name_to;
5298: l_invoice_type AR_Gta_Trx_Headers_All.INVOICE_TYPE%TYPE
5299: := p_invoice_type;
5300:

Line 5298: l_invoice_type AR_Gta_Trx_Headers_All.INVOICE_TYPE%TYPE

5294: l_customer_name_from AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE
5295: := p_customer_name_from;
5296: l_customer_name_to AR_Gta_Trx_Headers_All.BILL_TO_CUSTOMER_NAME%TYPE
5297: := p_customer_name_to;
5298: l_invoice_type AR_Gta_Trx_Headers_All.INVOICE_TYPE%TYPE
5299: := p_invoice_type;
5300:
5301: -- added by Allen Yang for bug 8848696 02-Sep-2009
5302: l_invoice_type_disp FND_LOOKUP_VALUES_VL.MEANING%TYPE;

Line 5312: AR_Gta_Trx_Headers_All

5308: CURSOR c_consolidation_trx_ids IS
5309: SELECT
5310: GTA_TRX_HEADER_ID
5311: FROM
5312: AR_Gta_Trx_Headers_All
5313: WHERE ORG_ID = p_org_id
5314: AND RA_GL_PERIOD = NVL(p_gl_period, RA_GL_PERIOD)
5315: AND SOURCE = 'AR'
5316: AND STATUS NOT IN ('CANCELLED') --fix bug 14078699

Line 5567: FROM AR_GTA_TRX_HEADERS_ALL

5563: , ar_gta_trx_util.Get_Gtainvoice_Amount(p_trx_header_id) AS "Amount")
5564: -- end modified by Allen
5565: INTO
5566: l_ret_xmlelement
5567: FROM AR_GTA_TRX_HEADERS_ALL
5568: WHERE GTA_TRX_HEADER_ID = p_trx_header_id;
5569: */
5570: SELECT Xmlforest(
5571: JGTHA.GTA_TRX_NUMBER AS "ConsolidationTrxNum"

Line 5586: FROM AR_GTA_TRX_HEADERS_ALL JGTHA

5582: , ar_gta_trx_util.Get_Gtainvoice_Amount(p_trx_header_id) AS "Amount")
5583: -- end modified by Allen
5584: INTO
5585: l_ret_xmlelement
5586: FROM AR_GTA_TRX_HEADERS_ALL JGTHA
5587: , FND_LOOKUP_VALUES_VL FLTV
5588: WHERE GTA_TRX_HEADER_ID = p_trx_header_id
5589: AND FLTV.LOOKUP_TYPE = 'AR_GTA_INVOICE_TYPE'
5590: AND JGTHA.INVOICE_TYPE = FLTV.LOOKUP_CODE;

Line 5675: AR_Gta_Trx_Headers_all jgtha

5671: AS "ConsolidatedAmount"))))
5672: INTO
5673: l_ret_xmlelement
5674: FROM
5675: AR_Gta_Trx_Headers_all jgtha
5676: , ra_customer_trx_all rcta
5677: , ra_cust_trx_types rctt
5678: WHERE jgtha.CONSOLIDATION_FLAG = '1'
5679: AND jgtha.SOURCE = 'AR'

Line 5683: FROM AR_Gta_Trx_Headers_all

5679: AND jgtha.SOURCE = 'AR'
5680: AND jgtha.Status='CONSOLIDATED'
5681: AND jgtha.CONSOLIDATION_TRX_NUM =
5682: (SELECT GTA_TRX_NUMBER
5683: FROM AR_Gta_Trx_Headers_all
5684: WHERE GTA_TRX_HEADER_ID = p_trx_header_id)
5685: AND rctt.CUST_TRX_TYPE_ID = rcta.CUST_TRX_TYPE_ID
5686: AND rcta.CUSTOMER_TRX_ID = jgtha.RA_TRX_ID;
5687:

Line 5741: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;

5737: l_org_id NUMBER;
5738: l_gta_header_id NUMBER;
5739: l_gta_amount NUMBER;
5740: l_gta_taxamount NUMBER;
5741: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5742: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5743: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5744: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5745: l_gta_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;

Line 5742: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;

5738: l_gta_header_id NUMBER;
5739: l_gta_amount NUMBER;
5740: l_gta_taxamount NUMBER;
5741: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5742: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5743: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5744: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5745: l_gta_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5746: l_gta_invoice_type_name VARCHAR2(80);

Line 5743: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;

5739: l_gta_amount NUMBER;
5740: l_gta_taxamount NUMBER;
5741: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5742: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5743: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5744: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5745: l_gta_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5746: l_gta_invoice_type_name VARCHAR2(80);
5747: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;

Line 5744: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;

5740: l_gta_taxamount NUMBER;
5741: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5742: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5743: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5744: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5745: l_gta_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5746: l_gta_invoice_type_name VARCHAR2(80);
5747: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
5748:

Line 5745: l_gta_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;

5741: l_gta_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5742: l_gta_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5743: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5744: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5745: l_gta_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5746: l_gta_invoice_type_name VARCHAR2(80);
5747: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
5748:
5749: l_gt_amount NUMBER;

Line 5747: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;

5743: l_gta_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5744: l_gta_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5745: l_gta_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5746: l_gta_invoice_type_name VARCHAR2(80);
5747: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
5748:
5749: l_gt_amount NUMBER;
5750: l_gt_taxamount NUMBER;
5751: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;

Line 5751: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;

5747: l_gta_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
5748:
5749: l_gt_amount NUMBER;
5750: l_gt_taxamount NUMBER;
5751: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5752: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5753: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5754: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5755: l_gt_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;

Line 5752: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;

5748:
5749: l_gt_amount NUMBER;
5750: l_gt_taxamount NUMBER;
5751: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5752: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5753: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5754: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5755: l_gt_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5756: l_gt_invoice_type_name VARCHAR2(80);

Line 5753: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;

5749: l_gt_amount NUMBER;
5750: l_gt_taxamount NUMBER;
5751: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5752: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5753: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5754: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5755: l_gt_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5756: l_gt_invoice_type_name VARCHAR2(80);
5757: l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;

Line 5754: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;

5750: l_gt_taxamount NUMBER;
5751: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5752: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5753: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5754: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5755: l_gt_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5756: l_gt_invoice_type_name VARCHAR2(80);
5757: l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;
5758: l_gt_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;

Line 5755: l_gt_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;

5751: l_gt_customer_name ar_gta_trx_headers_all.bill_to_customer_name%TYPE;
5752: l_gt_taxpayer_id ar_gta_trx_headers_all.tp_tax_registration_number%TYPE;
5753: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5754: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5755: l_gt_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5756: l_gt_invoice_type_name VARCHAR2(80);
5757: l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;
5758: l_gt_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
5759:

Line 5757: l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;

5753: l_gt_customer_bank_account ar_gta_trx_headers_all.bank_account_name_number%TYPE;
5754: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5755: l_gt_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5756: l_gt_invoice_type_name VARCHAR2(80);
5757: l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;
5758: l_gt_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
5759:
5760: l_amount_attr fnd_lookup_values.meaning%TYPE;
5761: l_taxamount_attr fnd_lookup_values.meaning%TYPE;

Line 5758: l_gt_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;

5754: l_gt_customer_address_phone ar_gta_trx_headers_all.customer_address_phone%TYPE;
5755: l_gt_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE;
5756: l_gt_invoice_type_name VARCHAR2(80);
5757: l_gt_invoice_number ar_gta_trx_headers_all.gt_invoice_number%TYPE;
5758: l_gt_trx_number ar_gta_trx_headers_all.gta_trx_number%TYPE;
5759:
5760: l_amount_attr fnd_lookup_values.meaning%TYPE;
5761: l_taxamount_attr fnd_lookup_values.meaning%TYPE;
5762: l_cust_name_attr fnd_lookup_values.meaning%TYPE;