APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on ZX_LINES

Line 730: , ZX_lines zx

726: , jg_zz_vat_trx_details JG
727: , fnd_lookup_values TLOOKUP
728: , fnd_lookup_values TBLLOOKUP
729: , Jg_Zz_Vat_Rep_Status Jzvrs
730: , ZX_lines zx
731: WHERE
732: NVL(AL.taxable_box, '99') = TBLLOOKUP.lookup_code
733: AND NVL(AL.tax_box, '99') = TLOOKUP.lookup_code
734: AND TLOOKUP.lookup_type = 'JGZZ_VAT_REPORT_BOXES'

Line 804: ,Record_Type_Code ZX_LINES.Record_Type_Code%type

800: ,cancel_flag jg_zz_vat_trx_details.cancel_flag%type
801: ,source_id jg_zz_vat_trx_details.taxable_item_source_id%type --Added for bug 11813288
802: ,Tax_Recoverable_Flag Jg_Zz_Vat_Trx_Details.Tax_Recoverable_Flag%Type
803: ,Tax_Recovery_Rate Jg_Zz_Vat_Trx_Details.Tax_Recovery_Rate%Type
804: ,Record_Type_Code ZX_LINES.Record_Type_Code%type
805: );
806:
807: TYPE r_vatbox_amounts IS RECORD
808: (

Line 1740: ZX_LINES ZXL

1736: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,
1737: JG_ZZ_VAT_REP_STATUS JZVRS,
1738: AP_INVOICES_ALL APINV,
1739: AP_INVOICE_LINES_ALL APINVL,
1740: ZX_LINES ZXL
1741: WHERE JZVRS.SOURCE = 'AP'
1742: AND JZVRS.VAT_REPORTING_ENTITY_ID in
1743: (p_vat_rep_entity_id, p_vat_rep_entity_id2,
1744: p_vat_rep_entity_id3, p_vat_rep_entity_id4,