APPS.OPI_DBI_OPM_COGS_PKG dependencies on OPI_DBI_COGS_LOG

Line 60: FROM opi_dbi_cogs_log l,

56:
57:
58: SELECT NVL(MIN(from_date), global_start_date) INTO l_from_date
59: FROM (SELECT tst.gl_trans_date from_date
60: FROM opi_dbi_cogs_log l,
61: gl_subr_tst tst
62: WHERE l.extraction_type = 'COGS_SUBLEDGER'
63: AND tst.subledger_id = l.transaction_id
64: UNION

Line 66: FROM opi_dbi_cogs_log l,

62: WHERE l.extraction_type = 'COGS_SUBLEDGER'
63: AND tst.subledger_id = l.transaction_id
64: UNION
65: SELECT tst.gl_trans_date from_date
66: FROM opi_dbi_cogs_log l,
67: gl_subr_led tst
68: WHERE l.extraction_type = 'COGS_SUBLEDGER'
69: AND tst.subledger_id = l.transaction_id
70: UNION

Line 72: FROM opi_dbi_cogs_log l,

68: WHERE l.extraction_type = 'COGS_SUBLEDGER'
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: );

Line 1296: FROM opi_dbi_cogs_log

1292:
1293: begin
1294: BEGIN
1295: SELECT transaction_id INTO l_last_trx_id
1296: FROM opi_dbi_cogs_log
1297: WHERE extraction_type = 'COGS_ICAP';
1298:
1299: EXCEPTION
1300: WHEN no_data_found THEN

Line 1330: merge INTO opi_dbi_cogs_log l

1326: l_new_trx_id,
1327: l_status,
1328: l_msg );
1329:
1330: merge INTO opi_dbi_cogs_log l
1331: using ( SELECT 'COGS_ICAP' extraction_type
1332: FROM dual ) d
1333: ON ( l.extraction_type = d.extraction_type )
1334: WHEN matched THEN UPDATE SET

Line 1388: FROM opi_dbi_cogs_log

1384:
1385:
1386: begin
1387: SELECT COUNT(*) INTO l_exception_count
1388: FROM opi_dbi_cogs_log
1389: WHERE error_message IS NOT NULL;
1390:
1391: l_missing_rate_count := report_missing_rate;
1392:

Line 1505: FROM opi_dbi_cogs_log

1501: -- 1. get subledger cogs
1502:
1503: BEGIN
1504: SELECT transaction_id INTO l_last_trx_id
1505: FROM opi_dbi_cogs_log
1506: WHERE extraction_type = 'OPM_COGS_SUBLEDGER';
1507:
1508:
1509: SELECT Nvl(MAX(subledger_id),l_last_trx_id)

Line 1556: merge INTO opi_dbi_cogs_log l

1552: l_batch_to_id,
1553: l_status,
1554: l_msg );
1555:
1556: merge INTO opi_dbi_cogs_log l
1557: using ( SELECT NULL organization_id,
1558: 'OPM_COGS_SUBLEDGER' extraction_type
1559: FROM dual ) d
1560: ON ( l.extraction_type = d.extraction_type )

Line 1663: merge INTO opi_dbi_cogs_log l

1659: l_status,
1660: l_msg ,
1661: p_degree);
1662:
1663: merge INTO opi_dbi_cogs_log l
1664: using ( SELECT NULL organization_id,
1665: 'OPM_COGS_SUBLEDGER' extraction_type
1666: FROM dual ) d
1667: ON ( l.extraction_type = d.extraction_type )

Line 1723: /* delete from opi_dbi_cogs_log */

1719: END IF;
1720:
1721:
1722: /* Deletes removed here and replaced in wrapper */
1723: /* delete from opi_dbi_cogs_log */
1724: /* where extraction_type like 'OPM%'; */
1725:
1726: /* delete from opi_dbi_cogs_stg */
1727: /* where source like 'OPM%'; */