DBA Data[Home] [Help]

APPS.JE_IT_XML_LISTING_PKG dependencies on JE_IT_LIST_PARTIES_ALL

Line 154: FROM je_it_list_parties_all je

150: ,ROUND(je.cm_vat_amt) VAT_AMT_CM
151: ,ROUND(je.cm_non_taxable_amt) NON_TAXABLE_AMT_CM
152: ,ROUND(je.cm_exempt_amt) EXEMPT_AMT_CM
153: ,ROUND(je.cm_taxable_vat_inv_amt) TAXABLE_VAT_INV_AMT_CM
154: FROM je_it_list_parties_all je
155: ,hz_cust_accounts hzca
156: ,hz_parties hzp
157: WHERE je.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
158: AND je.year_of_declaration = P_YEAR_OF_DECLARATION

Line 185: FROM je_it_list_parties_all je

181: ,ROUND(je.cm_non_taxable_amt) NON_TAXABLE_AMT_CM
182: ,ROUND(je.cm_exempt_amt) EXEMPT_AMT_CM
183: ,ROUND(je.cm_taxable_vat_amt) TAXABLE_VAT_AMT_CM
184: ,ROUND(je.cm_taxable_vat_inv_amt) TAXABLE_VAT_INV_AMT_CM
185: FROM je_it_list_parties_all je
186: ,ap_suppliers pv
187: WHERE je.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
188: AND je.year_of_declaration = P_YEAR_OF_DECLARATION
189: AND je.transmission_num = P_PROG_NUM