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

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 546: l_Ar_Trx_Id AR_Gta_Trx_Headers.Ra_Trx_Id%TYPE;

542: )
543: IS
544: l_procedure_name VARCHAR2(40):='Generate_Mapping_Rep';
545: l_no_data_message VARCHAR2(500);
546: l_Ar_Trx_Id AR_Gta_Trx_Headers.Ra_Trx_Id%TYPE;
547: l_Parameter Xmltype;
548: l_Summary Xmltype;
549: L_gt_currency Xmltype;
550: l_Ar_Trx Xmltype;

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 640: AR_Gta_Trx_Headers Gt

636: COUNT(*)
637: INTO
638: l_Gt_Rows
639: FROM
640: AR_Gta_Trx_Headers Gt
641: ,Ra_Customer_Trx Ar
642: WHERE Gt.Ra_Trx_Id=Ar.Customer_Trx_Id
643: AND Gt.Org_Id=P_Org_Id
644: 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 1010: ar_gta_trx_headers gta, fnd_lookup_values_vl lk --added by subba.

1006: ,gta.invoice_type invoice_type --added by subba.
1007: ,lk.meaning invoice_type_name --added by subba.
1008: ,gta.status--Yao Zhang add for bug#8765631
1009: FROM
1010: ar_gta_trx_headers gta, fnd_lookup_values_vl lk --added by subba.
1011: WHERE gta.ra_trx_id=l_ar_header_id
1012: AND gta.source='AR'
1013: AND (gta.status='COMPLETED' OR gta.status='CONSOLIDATED')--Yao Zhang modified for bug#8765631
1014: AND gta.latest_version_flag='Y'

Line 1037: ar_gta_trx_headers gt,

1033: , gt.gt_invoice_number
1034: , gt.invoice_type invoice_type
1035: , lk.meaning invoice_type_name
1036: FROM
1037: ar_gta_trx_headers gt,
1038: fnd_lookup_values_vl lk --added by Subba for R12.1
1039: WHERE gt.gta_trx_number=l_gta_trx_number
1040: AND gt.source='GT'
1041: AND gt.invoice_type = lk.lookup_code

Line 1054: ar_gta_trx_headers gta

1050: , AR_GTA_TRX_UTIL.Get_Gtainvoice_Tax_Amount(gta.gta_trx_header_id)
1051: taxamount
1052: , gta.gta_trx_number
1053: FROM
1054: ar_gta_trx_headers gta
1055: WHERE gta.ra_trx_id=l_ar_header_id
1056: AND gta.source='AR'
1057: AND gta.status<>'CANCELLED'
1058: AND gta.latest_version_flag='Y';

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 2229: ar_gta_trx_headers jgth

2225: ,round(jgtl.unit_price,2)--Qiong changed from jgtl.unit_price to round(,2) for bug10638369
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')

Line 2244: ar_gta_trx_headers jgth

2240: CURSOR c_gta_lines_not_enabled IS
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'

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 2267: ar_gta_trx_headers jgth

2263: SELECT
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'

Line 2326: ar_gta_trx_headers jgth

2322: )
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

Line 3564: ar_gta_trx_headers gta_header

3560: ,gta_line.amount
3561: ,gta_line.tax_amount
3562: ,gta_line.tax_rate
3563: FROM
3564: ar_gta_trx_headers gta_header
3565: ,ar_gta_trx_lines gta_line
3566: WHERE gta_header.ra_trx_id=l_ar_header_id
3567: AND gta_header.source='AR'
3568: AND gta_header.status='COMPLETED'

Line 3591: ar_gta_trx_headers gt_header

3587: ,gt_line.amount
3588: ,gt_line.tax_amount
3589: ,gt_line.tax_rate
3590: FROM
3591: ar_gta_trx_headers gt_header
3592: ,ar_gta_trx_lines gt_line
3593: WHERE gt_header.ra_trx_id=l_ar_header_id
3594: AND gt_header.source='GT'
3595: AND gt_line.gta_trx_header_id=gt_header.gta_trx_header_id

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 4335: FROM ar_gta_trx_headers

4331: l_description:=NULL;
4332: --the following code is added by Yao Zhang for bug#8765631
4333: SELECT COUNT(*)
4334: INTO l_consolidate_count
4335: FROM ar_gta_trx_headers
4336: WHERE ra_trx_id = l_ar_header_id
4337: AND status = 'CONSOLIDATED';
4338: IF l_consolidate_count>0
4339: THEN

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 4718: ar_gta_trx_headers gta

4714: ,ct.trx_date
4715: ,rac_bill_party.party_name customer_name
4716: ,ct.invoice_currency_code
4717: FROM
4718: ar_gta_trx_headers gta
4719: ,ra_customer_trx_all ct
4720: ,hz_cust_accounts rac_bill
4721: ,hz_parties rac_bill_party
4722: ,ra_cust_trx_line_gl_dist_all gd

Line 4786: ar_gta_trx_headers gth

4782: ,gth.ra_trx_number
4783: ,gth.gt_invoice_number
4784: ,gth.gta_trx_header_id
4785: FROM
4786: ar_gta_trx_headers gth
4787: WHERE gth.SOURCE='AR'--Yao Zhang add for bug#8765631
4788: AND (gth.status='COMPLETED' OR gth.status='CONSOLIDATED')
4789: AND gth.ra_trx_id=l_ar_trx_header_id;
4790: --gth.SOURCE='GT'

Line 4795: ar_gta_trx_headers gth

4791: CURSOR c_ar_trx_number_missing IS
4792: SELECT
4793: DISTINCT gth.ra_trx_number
4794: FROM
4795: ar_gta_trx_headers gth
4796: WHERE gth.SOURCE='AR'--Yao Zhang add for bug#8765631
4797: AND (gth.status='COMPLETED' OR gth.status='CONSOLIDATED')
4798: AND gth.ra_trx_id=l_ar_trx_header_id;
4799: --gth.SOURCE='GT'

Line 4806: FROM ar_gta_trx_headers gta

4802: SELECT gta.gta_trx_header_id
4803: ,gta.gta_trx_number
4804: ,gta.ra_gl_date
4805: ,gta.BILL_TO_CUSTOMER_NAME customer_name
4806: FROM ar_gta_trx_headers gta
4807: WHERE gta.consolidation_flag = '0'
4808: AND gta.status = 'COMPLETED'
4809: AND gta.SOURCE = 'AR'
4810: AND gta.org_id = l_org_id

Line 5275: l_consolidation_trx_id AR_Gta_Trx_Headers.GTA_TRX_HEADER_ID%TYPE;

5271: consolidation -- invoice which is consolidated into a consolidated invoice
5272: */
5273: l_procedure_name VARCHAR2(40):='Generate_Consol_Mapping_Rep';
5274: l_no_data_message VARCHAR2(500);
5275: l_consolidation_trx_id AR_Gta_Trx_Headers.GTA_TRX_HEADER_ID%TYPE;
5276: l_Parameter Xmltype;
5277: l_consolidation_trx Xmltype;
5278: l_consolidated_trxs Xmltype;
5279: l_consolidation_trxs Xmltype;

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 5354: AR_Gta_Trx_Headers

5350: COUNT(*)
5351: INTO
5352: l_consolidation_rows
5353: FROM
5354: AR_Gta_Trx_Headers
5355: WHERE ORG_ID = p_org_id
5356: AND RA_GL_PERIOD = NVL(p_gl_period, RA_GL_PERIOD)
5357: AND Source = 'AR'
5358: 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;

Line 5789: ar_gta_trx_headers gta, fnd_lookup_values_vl lk

5785: , gta.gta_trx_number
5786: ,gta.invoice_type invoice_type
5787: ,lk.meaning invoice_type_name
5788: FROM
5789: ar_gta_trx_headers gta, fnd_lookup_values_vl lk
5790: WHERE gta.gta_trx_header_id=l_gta_header_id
5791: AND gta.invoice_type = lk.lookup_code
5792: AND lk.lookup_type='AR_GTA_INVOICE_TYPE';
5793:

Line 5804: FROM ar_gta_trx_headers gt, fnd_lookup_values_vl lk

5800: gt.customer_address_phone customer_address_phone,
5801: gt.gt_invoice_number,
5802: gt.invoice_type invoice_type,
5803: lk.meaning invoice_type_name
5804: FROM ar_gta_trx_headers gt, fnd_lookup_values_vl lk
5805: WHERE gt.gta_trx_number IN
5806: (SELECT gta_trx_number
5807: FROM ar_gta_trx_headers gta
5808: WHERE gta.gta_trx_header_id = l_gta_header_id)

Line 5807: FROM ar_gta_trx_headers gta

5803: lk.meaning invoice_type_name
5804: FROM ar_gta_trx_headers gt, fnd_lookup_values_vl lk
5805: WHERE gt.gta_trx_number IN
5806: (SELECT gta_trx_number
5807: FROM ar_gta_trx_headers gta
5808: WHERE gta.gta_trx_header_id = l_gta_header_id)
5809: AND gt.SOURCE = 'GT'
5810: AND gt.invoice_type = lk.lookup_code
5811: AND lk.lookup_type = 'AR_GTA_INVOICE_TYPE';