APPS.ZX_AP_EXTRACT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2123: ap_invoice_distributions_all ap_dist,

2119: zx_det.unit_price ,
2120: nvl(ap_dist.accounting_date,zx_det.trx_line_gl_date),
2121: to_char(NULL) -- Bug10238948
2122: FROM zx_lines_det_factors zx_det,
2123: ap_invoice_distributions_all ap_dist,
2124: zx_rates_vl zx_rate
2125: WHERE zx_det.application_id = 200
2126: AND zx_det.entity_code = ''AP_INVOICES''
2127: AND zx_det.event_class_code in (''STANDARD INVOICES'',

Line 4170: FROM AP_INVOICE_DISTRIBUTIONS_ALL DIST

4166: ),
4167: 'N') = 'Y'
4168: )
4169: AND EXISTS (SELECT /*+ FIRST_ROWS(1) */ 1
4170: FROM AP_INVOICE_DISTRIBUTIONS_ALL DIST
4171: WHERE DIST.INVOICE_ID = DTL.TRX_ID
4172: AND NVL(DIST.POSTED_FLAG,'N')='N'
4173: AND ROWNUM = 1
4174: );