APPS.JE_ES_MODELO_EXT_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 25: jg_zz_vat_trx_details.billing_tp_address_id (value passed in parameter p_party_site_id) is actually a

21:
22: /** author: brathod
23: Modified following cursor to refer ap_supplier_sites_all to retrieve supplier address.
24: Cursor was wrongly refering to hz_party_sites_all and hz_locations as
25: jg_zz_vat_trx_details.billing_tp_address_id (value passed in parameter p_party_site_id) is actually a
26: supplier_site_id and not party_site_id. Please refer bug#5031773
27: */
28: CURSOR c_get_address IS
29: SELECT DECODE(p_modelo,'415',DECODE(SUBSTR(assa.country, 1, 25)

Line 160: , jg_zz_vat_trx_details JZVTD

156: , SUBSTR(HL.global_attribute3,1,2) global_attribute3
157: , SUBSTR(HL.global_attribute4,1,2) global_attribute4
158: , SUBSTR(HL.global_attribute5,1,2) global_attribute5
159: FROM jg_zz_vat_rep_status JZVRS
160: , jg_zz_vat_trx_details JZVTD
161: , hz_cust_acct_sites_all HCAS
162: , hz_party_sites HPS
163: , hr_locations HL
164: , fnd_territories FT

Line 502: FROM jg_zz_vat_trx_details JZVTD

498: ))
499: - NVL(AID.prepay_amount_remaining, 0 )* -1
500: )
501: INTO V_PREPAY_APPLIED
502: FROM jg_zz_vat_trx_details JZVTD
503: ,jg_zz_vat_rep_status JZVRS
504: ,ap_invoice_distributions AID
505: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
506: AND JZVTD.billing_trading_partner_id = p_vendor_id

Line 554: FROM jg_zz_vat_trx_details JZVTD

550: )
551: , g_cur_precision)
552: )
553: INTO V_PREPAY_APPLIED
554: FROM jg_zz_vat_trx_details JZVTD
555: ,jg_zz_vat_rep_status JZVRS
556: ,ap_invoice_distributions AID
557: ,ap_invoice_distributions PRE
558: ,hz_parties HP

Line 649: FROM JG_ZZ_VAT_TRX_DETAILS JVGT, JG_ZZ_VAT_REP_STATUS JZVRS

645: SELECT SUM(ROUND( NVL(JVGT.taxable_amt_funcl_curr,JVGT.taxable_amt ) , 2) )
646: + SUM(ROUND( NVL(JVGT.tax_amt_funcl_curr,JVGT.tax_amt ) , 2) ) arrenda_amount
647: -- SUM(ROUND(NVL(JVGT.trx_line_amt,0), 2)) arrenda_amount
648: INTO V_PREPAY_APPLIED
649: FROM JG_ZZ_VAT_TRX_DETAILS JVGT, JG_ZZ_VAT_REP_STATUS JZVRS
650: --, hz_cust_acct_sites_all HCAS
651: --, hz_party_sites HPS
652: --, hz_locations HL
653: --, fnd_territories FT

Line 768: , jg_zz_vat_trx_details JZVTD

764: ) CORRECTION_AMOUNT
765: $CORRECTION_TRX_SEL_COL$
766: $PROPERTY_FLAG_SEL_COL$
767: FROM jg_zz_vat_rep_status JZVRS
768: , jg_zz_vat_trx_details JZVTD
769: $MODELO_TABLE_LIST$
770: WHERE JZVRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$
771: --AND JZVRS.reporting_status_id = JZVTD.reporting_status_id
772: AND JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS

Line 953: lc_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;

949: lc_prev_vat_code VARCHAR2(400) :='';
950: lc_count NUMBER := 0;
951: lc_reporting_mode VARCHAR2(240);
952: --
953: lc_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
954: lc_company_name xle_registrations.registered_name%TYPE;
955: lc_registration_number xle_registrations.registration_number%TYPE;
956: lc_country hr_locations.country%TYPE;
957: lc_address1 hr_locations.address_line_1%TYPE;

Line 1409: , jg_zz_vat_trx_details JZVTD

1405: , ''347PR'', ''Y''
1406: , ''415_347'', ''N''
1407: , ''415_347PR'',''Y'') PROPERTY_RENTAL
1408: FROM jg_zz_vat_rep_status JZVRS
1409: , jg_zz_vat_trx_details JZVTD
1410: , ap_suppliers aps
1411: , ap_supplier_sites_all apss
1412: /**
1413: author:brathod