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.JE_ES_MODELO_EXT_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 223: INSERT INTO JG_ZZ_VAT_TRX_GT

219:
220: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'inserting with tipo 3: p_cust_tax_reg_num=' ||p_cust_tax_reg_num); END IF;
221:
222: -- dbms_output.put_line ('inserting ');
223: INSERT INTO JG_ZZ_VAT_TRX_GT
224: ( jg_info_v1 -- tipo
225: , jg_info_n2 -- importe -- sum_trx_line_amt
226: , jg_info_v11 -- nombre -- cust name
227: , jg_info_v12 -- nif -- cust tax ref

Line 287: FROM JG_ZZ_VAT_TRX_GT

283: , jg_info_v15 C_YEAR
284: , jg_info_v16 C_PERIOD
285: , jg_info_v17 C_OPERACION_TRIANGULAR
286: , rowid row_id
287: FROM JG_ZZ_VAT_TRX_GT
288: ORDER BY rpad(jg_info_v12,40,'A')
289: , jg_info_v1,jg_info_v15, jg_info_v16 desc;*/ -- Bug 5525421
290: /** This query is used to find out the report level information of the following 1. summ of correction amount
291: 2. sum non correction amount 3. number of correction records and 4. number of non correction records

Line 307: FROM JG_ZZ_VAT_TRX_GT JZVTG

303: , SUM(jg_info_n10) C_RUNNING_TOTAL
304: , jg_info_v23 SIGN
305: , jg_info_v18 POST_CODE
306: , jg_info_v17 OPERACION_TRIANGULAR
307: FROM JG_ZZ_VAT_TRX_GT JZVTG
308: WHERE NVL(JZVTG.jg_info_v30, 'X') <>'H'
309: -- AND jg_info_v27 = P_DISPLAY_PERIOD
310: AND jg_info_v27 = DECODE(P_DISPLAY_PERIOD,'OA',jg_info_v27,P_DISPLAY_PERIOD) -- Modified for Bug 7486406
311: GROUP BY jg_info_v21

Line 439: UPDATE JG_ZZ_VAT_TRX_GT

435: ln_cuenta_3_4 := 0;
436:
437: END LOOP;
438:
439: UPDATE JG_ZZ_VAT_TRX_GT
440: SET jg_info_N1 = ln_grp_cuenta_1
441: , jg_info_N2 = ln_grp_imp_1
442: , jg_info_N3 = ln_grp_cuenta_3_4
443: , jg_info_N4 = ln_grp_imp_2

Line 608: Commented to use jg_zz_vat_trx_detail instead of JG_ZZ_VAT_TRX_GT

604: BEGIN
605:
606: /**
607: author: brathod
608: Commented to use jg_zz_vat_trx_detail instead of JG_ZZ_VAT_TRX_GT
609: SELECT SUM(ROUND(DECODE( NVL(JVGT.jg_info_n8,0)
610: ,0 , JVGT.jg_info_n6
611: , JVGT.jg_info_n8
612: )

Line 616: FROM JG_ZZ_VAT_TRX_GT JVGT

612: )
613: , g_cur_precision)
614: )
615: INTO V_PREPAY_APPLIED
616: FROM JG_ZZ_VAT_TRX_GT JVGT
617: , hz_cust_acct_sites_all HCAS
618: , hz_party_sites HPS
619: , hz_locations HL
620: , fnd_territories FT

Line 641: 1. Add code below to use jg_zz_vat_trx_detail instead of JG_ZZ_VAT_TRX_GT

637: ,'347PR');*/
638:
639: /**
640: author: brathod
641: 1. Add code below to use jg_zz_vat_trx_detail instead of JG_ZZ_VAT_TRX_GT
642: 2. Commented TCA related tables as they are not required to fetch the amount and directly joined HCSU with JVGT*
643: */
644:
645: SELECT SUM(ROUND( NVL(JVGT.taxable_amt_funcl_curr,JVGT.taxable_amt ) , 2) )

Line 974: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

970: --
971: lc_jgzz_modelo_query VARCHAR2(32000);
972: lc_jgzz_modelo_query1 VARCHAR2(32000);
973: --
974: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
975: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
976: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 975: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

971: lc_jgzz_modelo_query VARCHAR2(32000);
972: lc_jgzz_modelo_query1 VARCHAR2(32000);
973: --
974: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
975: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
976: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 976: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

972: lc_jgzz_modelo_query1 VARCHAR2(32000);
973: --
974: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
975: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
976: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

973: --
974: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
975: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
976: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

974: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
975: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
976: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

975: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
976: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
983: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

976: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
983: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
984: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

977: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
983: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
984: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
985: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

978: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
983: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
984: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
985: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
986: lc_trx_period VARCHAR2(2);

Line 983: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

979: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
983: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
984: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
985: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
986: lc_trx_period VARCHAR2(2);
987: lc_print_year NUMBER;

Line 984: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

980: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
983: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
984: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
985: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
986: lc_trx_period VARCHAR2(2);
987: lc_print_year NUMBER;
988: lc_print_period VARCHAR2(2);

Line 985: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

981: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
982: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
983: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
984: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
985: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
986: lc_trx_period VARCHAR2(2);
987: lc_print_year NUMBER;
988: lc_print_period VARCHAR2(2);
989: lc_property_retail_flag JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 989: lc_property_retail_flag JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

985: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
986: lc_trx_period VARCHAR2(2);
987: lc_print_year NUMBER;
988: lc_print_period VARCHAR2(2);
989: lc_property_retail_flag JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
990: lc_address_detail JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
991: --
992: ln_base_imponiable NUMBER;
993: ln_running_total NUMBER;

Line 990: lc_address_detail JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

986: lc_trx_period VARCHAR2(2);
987: lc_print_year NUMBER;
988: lc_print_period VARCHAR2(2);
989: lc_property_retail_flag JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
990: lc_address_detail JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
991: --
992: ln_base_imponiable NUMBER;
993: ln_running_total NUMBER;
994: ln_formerly_decl_amt NUMBER;

Line 1130: INSERT INTO JG_ZZ_VAT_TRX_GT

1126: END IF;
1127: -- dbms_output.put_line ('BEFORE INSERT HEADER');
1128: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'BEFORE INSERT HEADER'); END IF;
1129:
1130: INSERT INTO JG_ZZ_VAT_TRX_GT
1131: (jg_info_v1 -- curr_code
1132: ,jg_info_v2 -- entity_name
1133: ,jg_info_v3 -- taxpayer_id
1134: ,jg_info_v4 -- company_name

Line 1216: Only reporting entity related information is populated in JG_ZZ_VAT_TRX_GT global temp table.

1212: /**
1213: author: brathod
1214: date : 23/05/2006
1215: User has requested "Generic Extract". Hence no need to apply report specific filters.
1216: Only reporting entity related information is populated in JG_ZZ_VAT_TRX_GT global temp table.
1217: Returning control from here to continue with xml data template query processing
1218: */
1219:
1220: IF (P_REPORT_NAME IS NULL) THEN

Line 1780: FROM JG_ZZ_VAT_TRX_GT M349

1776:
1777: begin
1778: SELECT NVL(jg_info_n10,0) -- running total
1779: INTO ln_formerly_decl_amt
1780: FROM JG_ZZ_VAT_TRX_GT M349
1781: WHERE RTRIM(jg_info_v11) = RTRIM(lc_tax_registration_number)
1782: AND RTRIM(jg_info_v12) = RTRIM(lc_customer_name)
1783: AND jg_info_n13 = lc_correction_year -- correction year
1784: AND jg_info_v27 = lc_correction_period -- correction period

Line 1799: /* UPDATE JG_ZZ_VAT_TRX_GT

1795: -- update running total
1796: --
1797: -- As per R11i logic this update should happend after the insert. Hence moving this to after insert.
1798:
1799: /* UPDATE JG_ZZ_VAT_TRX_GT
1800: SET jg_info_n10 = ln_formerly_decl_amt + ln_ncorrection_amount
1801: WHERE RTRIM(jg_info_v15) = RTRIM(lc_correction_year) --RTRIM(SUBSTR(lc_correction_year,3,2))
1802: AND RTRIM(jg_info_v16) = RTRIM(lc_correction_period)
1803: AND jg_info_v14 IS NOT NULL

Line 1821: INSERT INTO JG_ZZ_VAT_TRX_GT

1817: G_LINENO := '1.6.2.8';
1818: END IF;
1819: G_LINENO := '1.6.3';
1820:
1821: INSERT INTO JG_ZZ_VAT_TRX_GT
1822: ( jg_info_v1 -- lc_clave_operation lc_clave_operation
1823: , jg_info_v11 -- c_modelo_rec.tax_registration_number lc_tax_registration_number
1824: , jg_info_v12 -- c_modelo_rec.customer_name lc_customer_name
1825: , jg_info_v13 -- c_modelo_rec.customer_address_id lc_customer_address_id

Line 1884: UPDATE JG_ZZ_VAT_TRX_GT

1880: IF P_MODELO = '349' THEN
1881: IF P_REPORT_NAME = 'JEESAMOR' THEN
1882: IF lc_correction_year IS NOT NULL AND lc_correction_period IS NOT NULL THEN --IS a Correction
1883:
1884: UPDATE JG_ZZ_VAT_TRX_GT
1885: SET jg_info_n10 = ln_formerly_decl_amt + ln_ncorrection_amount
1886: WHERE RTRIM(jg_info_v15) = RTRIM(lc_correction_year) --RTRIM(SUBSTR(lc_correction_year,3,2))
1887: AND RTRIM(jg_info_v16) = RTRIM(lc_correction_period)
1888: AND jg_info_v14 IS NOT NULL

Line 2295: INSERT INTO JG_ZZ_VAT_TRX_GT

2291:
2292: G_LINENO := '2.4.7.1';
2293: ln_sum_trx_line_amt := ln_sum_trx_line_amt - ln_arrenda_amount ;
2294:
2295: INSERT INTO JG_ZZ_VAT_TRX_GT
2296: ( jg_info_v1 -- lc_clave_operation
2297: , jg_info_n2 -- ln_arrenda_amount
2298: , jg_info_v11 -- lc_tax_registration_number
2299: , jg_info_v12 -- c_modelo_rec.customer_name

Line 2338: INSERT INTO JG_ZZ_VAT_TRX_GT

2334: END IF;
2335: G_LINENO := '2.4.8';
2336: if ln_sum_trx_line_amt >0 then
2337: G_LINENO := '2.4.8.1';
2338: INSERT INTO JG_ZZ_VAT_TRX_GT
2339: ( jg_info_v1 -- lc_clave_operation
2340: , jg_info_n2 -- ln_sum_trx_line_amt
2341: , jg_info_v11 -- lc_tax_registration_number
2342: , jg_info_v12 -- c_modelo_rec.customer_name

Line 2421: FROM JG_ZZ_VAT_TRX_GT M349

2417:
2418: begin
2419: SELECT NVL(jg_info_n10,0) -- running total
2420: INTO ln_formerly_decl_amt
2421: FROM JG_ZZ_VAT_TRX_GT M349
2422: WHERE RTRIM(jg_info_v11) = RTRIM(lc_tax_registration_number)
2423: AND RTRIM(jg_info_v12) = RTRIM(lc_customer_name)
2424: AND jg_info_n13 = lc_correction_year -- correction year -- Bug 5525421
2425: AND jg_info_v27 = lc_correction_period -- correction period -- Bug 5525421

Line 2437: /* UPDATE JG_ZZ_VAT_TRX_GT

2433: G_LINENO := '2.4.10.2.7';
2434: --
2435: -- update running total
2436: -- -- Bug 5525421 As per R11i logic this update should happend after the insert. Hence moving this to after insert.
2437: /* UPDATE JG_ZZ_VAT_TRX_GT
2438: SET jg_info_n10 = ln_formerly_decl_amt + ln_ncorrection_amount
2439: WHERE RTRIM(jg_info_v15) = RTRIM(lc_correction_year)--RTRIM(SUBSTR(lc_correction_year,3,2))
2440: AND RTRIM(jg_info_v16) = RTRIM(lc_correction_period)
2441: AND jg_info_v15 IS NOT NULL

Line 2458: INSERT INTO JG_ZZ_VAT_TRX_GT

2454: G_LINENO := '2.5';
2455:
2456: IF P_MODELO <> '347' THEN
2457: G_LINENO := '2.5.1';
2458: INSERT INTO JG_ZZ_VAT_TRX_GT
2459: ( jg_info_v1 -- lc_clave_operation
2460: , jg_info_v11 -- c_modelo_rec.tax_registration_number
2461: , jg_info_v12 -- c_modelo_rec.customer_name
2462: , jg_info_v13 -- c_modelo_rec.customer_address_id

Line 2521: UPDATE JG_ZZ_VAT_TRX_GT

2517: IF P_MODELO = '349' THEN
2518: IF P_REPORT_NAME = 'JEESAMOR' THEN
2519: IF lc_correction_year IS NOT NULL AND lc_correction_period IS NOT NULL THEN --IS a Correction
2520:
2521: UPDATE JG_ZZ_VAT_TRX_GT
2522: SET jg_info_n10 = ln_formerly_decl_amt + ln_ncorrection_amount
2523: WHERE RTRIM(jg_info_v15) = RTRIM(lc_correction_year)--RTRIM(SUBSTR(lc_correction_year,3,2))
2524: AND RTRIM(jg_info_v16) = RTRIM(lc_correction_period)
2525: AND jg_info_v15 IS NOT NULL

Line 2553: FROM JG_ZZ_VAT_TRX_GT

2549: G_LINENO := '2.6';
2550:
2551: SELECT COUNT(*)
2552: INTO P_REC_COUNT
2553: FROM JG_ZZ_VAT_TRX_GT
2554: WHERE NVL(jg_info_v30,'X') <> 'H';
2555:
2556: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';
2557:

Line 2556: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';

2552: INTO P_REC_COUNT
2553: FROM JG_ZZ_VAT_TRX_GT
2554: WHERE NVL(jg_info_v30,'X') <> 'H';
2555:
2556: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';
2557:
2558: G_LINENO := '2.7';
2559: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT='||P_REC_COUNT); END IF;
2560: IF P_REPORT_NAME = 'JEESAMOR' THEN

Line 2559: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT='||P_REC_COUNT); END IF;

2555:
2556: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';
2557:
2558: G_LINENO := '2.7';
2559: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT='||P_REC_COUNT); END IF;
2560: IF P_REPORT_NAME = 'JEESAMOR' THEN
2561: G_LINENO := '2.7.1';
2562:
2563: IF P_MODELO = '347' THEN

Line 2565: UPDATE JG_ZZ_VAT_TRX_GT

2561: G_LINENO := '2.7.1';
2562:
2563: IF P_MODELO = '347' THEN
2564: G_LINENO := '2.7.1.1';
2565: UPDATE JG_ZZ_VAT_TRX_GT
2566: SET jg_info_n11 = ( SELECT count(*)
2567: FROM JG_ZZ_VAT_TRX_GT
2568: WHERE jg_info_v1 <> '3'
2569: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_D

Line 2567: FROM JG_ZZ_VAT_TRX_GT

2563: IF P_MODELO = '347' THEN
2564: G_LINENO := '2.7.1.1';
2565: UPDATE JG_ZZ_VAT_TRX_GT
2566: SET jg_info_n11 = ( SELECT count(*)
2567: FROM JG_ZZ_VAT_TRX_GT
2568: WHERE jg_info_v1 <> '3'
2569: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_D
2570: , jg_info_n12 = ( SELECT count(*)
2571: FROM JG_ZZ_VAT_TRX_GT

Line 2571: FROM JG_ZZ_VAT_TRX_GT

2567: FROM JG_ZZ_VAT_TRX_GT
2568: WHERE jg_info_v1 <> '3'
2569: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_D
2570: , jg_info_n12 = ( SELECT count(*)
2571: FROM JG_ZZ_VAT_TRX_GT
2572: WHERE jg_info_v1 = '3'
2573: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_I
2574: , jg_info_n13 = ( SELECT DECODE(G_CURRENCY_CODE
2575: , 'EUR' ,(SUM(jg_info_n2)*100)

Line 2577: FROM JG_ZZ_VAT_TRX_GT

2573: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_I
2574: , jg_info_n13 = ( SELECT DECODE(G_CURRENCY_CODE
2575: , 'EUR' ,(SUM(jg_info_n2)*100)
2576: , SUM(jg_info_n2))
2577: FROM JG_ZZ_VAT_TRX_GT
2578: WHERE jg_info_v1 <> '3') -- CP_TOTAL_AMT_DEC_D
2579: , jg_info_n14 = ( SELECT SUM(jg_info_n2)
2580: FROM JG_ZZ_VAT_TRX_GT
2581: WHERE jg_info_v1 = '3'

Line 2580: FROM JG_ZZ_VAT_TRX_GT

2576: , SUM(jg_info_n2))
2577: FROM JG_ZZ_VAT_TRX_GT
2578: WHERE jg_info_v1 <> '3') -- CP_TOTAL_AMT_DEC_D
2579: , jg_info_n14 = ( SELECT SUM(jg_info_n2)
2580: FROM JG_ZZ_VAT_TRX_GT
2581: WHERE jg_info_v1 = '3'
2582: AND NVL(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_I
2583: , jg_info_n15 = ( SELECT count(*)
2584: FROM JG_ZZ_VAT_TRX_GT

Line 2584: FROM JG_ZZ_VAT_TRX_GT

2580: FROM JG_ZZ_VAT_TRX_GT
2581: WHERE jg_info_v1 = '3'
2582: AND NVL(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_I
2583: , jg_info_n15 = ( SELECT count(*)
2584: FROM JG_ZZ_VAT_TRX_GT
2585: WHERE nvl(jg_info_v30,'X') <> 'H' ) -- CP_NO_OF_TYPE2
2586: WHERE jg_info_v30 = 'H';
2587: G_LINENO := '2.7.1.2';
2588:

Line 2591: UPDATE JG_ZZ_VAT_TRX_GT

2587: G_LINENO := '2.7.1.2';
2588:
2589: ELSIF P_MODELO = '415' THEN /** author:brathod; Modified for condition from P_MODELO='347' */
2590: G_LINENO := '2.7.1.3';
2591: UPDATE JG_ZZ_VAT_TRX_GT
2592: SET ( jg_info_n11 -- CS_IMP_VENTAS
2593: , jg_info_n12 -- CS_NUMERO_VENTAS
2594: , jg_info_n13 -- CS_IMP_MEDIACION
2595: , jg_info_n14 -- CS_NUMERO_MEDIACION

Line 2618: FROM JG_ZZ_VAT_TRX_GT

2614: , SUM( DECODE( jg_info_v1
2615: , 'C', 1
2616: , 0 ) ) CF_NUMERO_COMPRAS
2617:
2618: FROM JG_ZZ_VAT_TRX_GT
2619: WHERE NVL(jg_info_v30,'X') <> 'H'
2620: )
2621: WHERE jg_info_v30 = 'H';
2622: G_LINENO := '2.7.1.4';