APPS.JE_ES_MODELO_EXT_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 159: FROM jg_zz_vat_rep_status JZVRS

155: LTRIM(HL.address_line_3||'Z','1234567890')) - 1) address3
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

Line 503: ,jg_zz_vat_rep_status JZVRS

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
507: AND JZVTD.trx_type_mng = 'PREPAYMENT'

Line 555: ,jg_zz_vat_rep_status JZVRS

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
559: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id

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 767: FROM jg_zz_vat_rep_status JZVRS

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

Line 773: FROM jg_zz_vat_rep_status JZRS

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
773: FROM jg_zz_vat_rep_status JZRS
774: WHERE JZRS.vat_reporting_entity_id = $P_VAT_REP_ENTITY_ID$
775: AND JZRS.source IN ( ''AP'', ''AR'' ))
776: AND JZVTD.extract_source_ledger IN ( ''AP'', ''AR'' )
777: AND JZVRS.source IN ( ''AP'', ''AR'' )

Line 1408: FROM jg_zz_vat_rep_status JZVRS

1404: , ''347'', ''N''
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: /**