DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on STANDARD

Line 2251: and zx_dist.event_class_code IN ('STANDARD INVOICES',

2247: where tax_dist.invoice_id = c_invoice_id
2248: and tax_dist.invoice_id = zx_dist.trx_id
2249: and zx_dist.application_id = 200
2250: and zx_dist.entity_code = 'AP_INVOICES'
2251: and zx_dist.event_class_code IN ('STANDARD INVOICES',
2252: 'PREPAYMENT INVOICES',
2253: 'EXPENSE REPORTS')
2254: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')
2255: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id

Line 2459: and zx_dist.event_class_code IN ('STANDARD INVOICES',

2455: where tax_dist.invoice_id = c_invoice_id
2456: and tax_dist.invoice_id = zx_dist.trx_id
2457: and zx_dist.application_id = 200
2458: and zx_dist.entity_code = 'AP_INVOICES'
2459: and zx_dist.event_class_code IN ('STANDARD INVOICES',
2460: 'PREPAYMENT INVOICES',
2461: 'EXPENSE REPORTS')
2462: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')
2463: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id

Line 2725: -- query to get the Distributions for that standard invoice

2721:
2722: IF ( l_ok_to_cancel = TRUE AND l_invoice_type_lookup_code <> 'PREPAYMENT' ) THEN
2723:
2724: l_itm_dist_count := 0;
2725: -- query to get the Distributions for that standard invoice
2726: SELECT COUNT(*) INTO l_itm_dist_count
2727: FROM ap_invoice_distributions_all aid
2728: WHERE aid.invoice_id = p_line_rec.invoice_id
2729: AND aid.prepay_distribution_id is not null