DBA Data[Home] [Help]

APPS.JG_ZZ_PTCE_DT_PKG dependencies on AP_INVOICE_LINES

Line 109: ap_invoice_lines il,

105: -- ,sum(nvl(id.TOTAL_DIST_BASE_AMOUNT,id.base_amount)) base_amount --Added for bug 14317864 -- commented for bug 14791442
106: ,sum(decode(id.TOTAL_DIST_BASE_AMOUNT,0,id.amount,null,id.amount,id.TOTAL_DIST_BASE_AMOUNT)) base_amount -- Added for bug 14791442
107: FROM
108: ap_invoices i,
109: ap_invoice_lines il,
110: ap_invoice_distributions id,
111: gl_code_combinations gl,
112: jg_zz_vat_rep_entities repent
113: WHERE repent.vat_reporting_entity_id = p_reporting_entity_id