APPS.OPI_DBI_OPM_COGS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 73: ap_invoice_distributions_all aid

69: AND tst.subledger_id = l.transaction_id
70: UNION
71: SELECT aid.accounting_date from_date
72: FROM opi_dbi_cogs_log l,
73: ap_invoice_distributions_all aid
74: WHERE l.extraction_type = 'COGS_AP'
75: AND aid.invoice_distribution_id = l.transaction_id
76: );
77:

Line 667: FROM ap_invoice_distributions_all aid,

663: gsob.currency_code currency_code,
664: fii_currency.get_global_rate_primary
665: (gsob.currency_code, trunc( max(aid.accounting_date)) ) cogs_conversion_rate,
666: SUM( Nvl(aid.base_amount, aid.amount) ) cogs_val_b
667: FROM ap_invoice_distributions_all aid,
668: ap_invoices_all ai,
669: ra_customer_trx_lines_all rcl,
670: oe_order_lines_all l,
671: oe_order_lines_all pl,

Line 1302: FROM ap_invoice_distributions_all

1298:
1299: EXCEPTION
1300: WHEN no_data_found THEN
1301: SELECT Nvl( MIN(invoice_distribution_id), 0) INTO l_last_trx_id
1302: FROM ap_invoice_distributions_all
1303: WHERE accounting_date >= global_start_date;
1304:
1305: BIS_COLLECTION_UTILITIES.PUT_LINE('S, ICAP '|| l_last_trx_id );
1306: --l_last_trx_id := 0;