APPS.JE_IT_INVOICES_ABOVE_THRESHOLD dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 121: FROM jg_zz_vat_rep_entities

117: ------------------------------------------
118:
119: SELECT legal_entity_id
120: INTO g_legal_entity_id
121: FROM jg_zz_vat_rep_entities
122: WHERE VAT_REPORTING_ENTITY_ID = g_vat_reporting_entity_id;
123:
124: EXCEPTION
125: WHEN OTHERS THEN

Line 651: jg_zz_vat_rep_entities repent,

647: iby_payment_methods_vl alc, -- ap_lookup_codes alc,
648: (SELECT distinct person_id ,national_identifier
649: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf,
650: je_it_setup_doc_seqs_all ds,
651: jg_zz_vat_rep_entities repent,
652: hz_parties hp,
653: ap_invoice_distributions_all itemdist,
654: ap_invoice_lines_all itemline
655:

Line 1120: jg_zz_vat_rep_entities repent,

1116: hz_cust_acct_sites_all hcas,
1117: hz_party_sites hps,
1118: hz_locations hl,
1119: je_it_setup_doc_seqs_all ds,
1120: jg_zz_vat_rep_entities repent,
1121: zx_lines_v zx,
1122: ra_customer_trx_lines_all itemgdf
1123: where --rct.customer_trx_id = 665616 AND
1124: zx.trx_id = rct.customer_trx_id

Line 1254: jg_zz_vat_rep_entities repent,

1250: hz_cust_acct_sites_all hcas,
1251: hz_party_sites hps,
1252: hz_locations hl,
1253: je_it_setup_doc_seqs_all ds,
1254: jg_zz_vat_rep_entities repent,
1255: zx_lines_v zx,
1256: ra_customer_trx_lines_all itemgdf
1257: where --rct.customer_trx_id = 665616 AND
1258: zx.trx_id = rct.customer_trx_id