eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on OPI_DBI_INV_VALUE_LOG

Line 44: DELETE FROM OPI_DBI_INV_VALUE_LOG log

40: bis_collection_utilities.put_line('... OPI_DBI_INV_VALUE_F');
41:
42: l_stmt_num := 30;
43: /* Truncating Log Table */
44: DELETE FROM OPI_DBI_INV_VALUE_LOG log
45: WHERE type IN ('GSL','OID');
46: bis_collection_utilities.put_line('... OPI_DBI_INV_VALUE_LOG');
47:
48: l_stmt_num := 40;

Line 46: bis_collection_utilities.put_line('... OPI_DBI_INV_VALUE_LOG');

42: l_stmt_num := 30;
43: /* Truncating Log Table */
44: DELETE FROM OPI_DBI_INV_VALUE_LOG log
45: WHERE type IN ('GSL','OID');
46: bis_collection_utilities.put_line('... OPI_DBI_INV_VALUE_LOG');
47:
48: l_stmt_num := 40;
49: /* Truncating Conversion Rates Table */
50: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_CONVERSION_RATES ';

Line 95: FROM opi_dbi_inv_value_log log, sy_orgn_mst o

91: l_stmt_num NUMBER;
92:
93: CURSOR inception_date_cursor IS
94: SELECT o.orgn_code co_code, log.transaction_date inception_date
95: FROM opi_dbi_inv_value_log log, sy_orgn_mst o
96: WHERE log.type= 'OID'
97: AND o.organization_id = log.organization_id
98: AND g_global_start_date > log.transaction_date;
99:

Line 108: The following insert statement creates OPM Inception Balance rows in opi_dbi_inv_value_log, one for

104:
105: l_stmt_num := 20;
106:
107: /*
108: The following insert statement creates OPM Inception Balance rows in opi_dbi_inv_value_log, one for
109: each co_code represented in gl_subr_led. Each purge will be for a single company, so this is the
110: right level of granularity. If the global_start_date precedes the available data, it is important
111: that all of a company's rows be preserved. In such a case, if one company has less history than another,
112: then we need to know the shortenned history so that the correct costing date is used.

Line 114: INSERT INTO opi_dbi_inv_value_log

110: right level of granularity. If the global_start_date precedes the available data, it is important
111: that all of a company's rows be preserved. In such a case, if one company has less history than another,
112: then we need to know the shortenned history so that the correct costing date is used.
113: */
114: INSERT INTO opi_dbi_inv_value_log
115: (
116: organization_id,
117: transaction_id,
118: transaction_date,

Line 149: tabname => 'OPI_DBI_INV_VALUE_LOG',

145: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' company inception date rows created.');
146:
147: fnd_stats.gather_table_stats(
148: ownname => g_opi_schema,
149: tabname => 'OPI_DBI_INV_VALUE_LOG',
150: percent => 10);
151: /*
152: The following minimum inception date is calculated for two purposes:
153: (1) to assist in the quick determination of whether any data is clipped by the global_start_date

Line 158: FROM opi_dbi_inv_value_log

154: (2) to be returned by this procedure for passing to the daily activity collection, letting
155: it know that it is being called in an initial mode.
156: */
157: SELECT MIN(transaction_date) INTO l_min_inception_date
158: FROM opi_dbi_inv_value_log
159: WHERE type = 'OID';
160:
161: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' l_min_inception_date values determined.');
162:

Line 185: UPDATE opi_dbi_inv_value_log

181: TO_CHAR(ROUND(g_global_start_date - id.inception_date))
182: );
183: END LOOP;
184:
185: UPDATE opi_dbi_inv_value_log
186: SET transaction_date = g_global_start_date
187: WHERE type = 'OID'
188: AND g_global_start_date > transaction_date;
189:

Line 229: opi_dbi_inv_value_log sd,

225: ic_loct_inv
226: UNION ALL
227: SELECT t.item_id, t.whse_code, -t.trans_qty
228: FROM
229: opi_dbi_inv_value_log sd,
230: sy_orgn_mst o,
231: ic_tran_pnd t
232: WHERE
233: sd.type = 'OID'

Line 241: opi_dbi_inv_value_log sd,

237: AND t.trans_date >= sd.transaction_date
238: UNION ALL
239: SELECT t.item_id, t.whse_code, -t.trans_qty
240: FROM
241: opi_dbi_inv_value_log sd,
242: sy_orgn_mst o,
243: ic_tran_cmp t
244: WHERE
245: sd.type = 'OID'

Line 282: opi_dbi_inv_value_log id,

278: SELECT
279: DISTINCT q.whse_code, w.orgn_code, q.item_id, id.transaction_date
280: FROM
281: opi_dbi_opm_inception_qty q,
282: opi_dbi_inv_value_log id,
283: ic_whse_mst w,
284: sy_orgn_mst o,
285: sy_orgn_mst c
286: WHERE

Line 459: opi_dbi_inv_value_log sd

455: FROM
456: ic_tran_pnd pnd,
457: ic_xfer_mst xfer,
458: sy_orgn_mst o,
459: opi_dbi_inv_value_log sd
460: WHERE
461: pnd.doc_id = xfer.transfer_id
462: AND xfer.transfer_status = 2 -- not received yet
463: AND pnd.doc_type = 'XFER' -- inventory transfer

Line 503: opi_dbi_inv_value_log sd

499: ic_item_mst_b ic_item,
500: mtl_interorg_parameters mip,
501: sy_orgn_mst o,
502: sy_orgn_mst c,
503: opi_dbi_inv_value_log sd
504: WHERE supply_type_code in ('SHIPMENT' , 'RECEIVING')
505: AND intransit_owning_org_id is not NULL -- necessary for
506: -- intransit
507: AND mip.from_organization_id = sup.from_organization_id

Line 558: opi_dbi_inv_value_log sd

554: FROM
555: ic_tran_vw1 pnd,
556: ic_xfer_mst xfer,
557: sy_orgn_mst o,
558: opi_dbi_inv_value_log sd
559: WHERE pnd.completed_ind = 1 -- completed transfer
560: -- view sets completed_ind to 1
561: -- for everything in the ic_tran_cmp
562: AND pnd.doc_type = 'XFER' -- inventory transfer

Line 613: opi_dbi_inv_value_log sd

609: mtl_system_items_b msi,
610: ic_item_mst_b ic_item,
611: mtl_interorg_parameters mip,
612: sy_orgn_mst o,
613: opi_dbi_inv_value_log sd
614: WHERE ic_tran.completed_ind = 1 -- but complete
615: AND ic_tran.doc_type = 'OMSO' -- internal sales order shipment
616: AND ic_tran.line_id = oola.line_id -- get line id details
617: AND oola.source_document_type_id = 10 --ensure this is internal

Line 669: opi_dbi_inv_value_log sd

665: mtl_system_items_b msi,
666: ic_item_mst_b ic_item,
667: mtl_interorg_parameters mip,
668: sy_orgn_mst o,
669: opi_dbi_inv_value_log sd
670: WHERE ic_tran.completed_ind = 1 -- but complete
671: AND ic_tran.doc_type = 'PORC' -- internal sales order shipment
672: AND rcv.transaction_id = ic_tran.line_id
673: AND req.requisition_line_id = rcv.requisition_line_id

Line 755: opi_dbi_inv_value_log log

751: gl_subr_led l,
752: gme_batch_header h,
753: ic_whse_mst w,
754: sy_orgn_mst o,
755: opi_dbi_inv_value_log log
756: where
757: l.doc_type = 'PROD'
758: and l.acct_ttl_type = 1530
759: and l.doc_id = h.batch_id

Line 783: opi_dbi_inv_value_log log

779: sy_orgn_mst o,
780: sy_orgn_mst c,
781: ic_item_mst_b i,
782: mtl_system_items_b msi,
783: opi_dbi_inv_value_log log
784: WHERE
785: w.whse_code = ib.whse_code
786: AND i.item_id = ib.item_id
787: AND msi.segment1 = i.item_no

Line 810: INSERT INTO opi_dbi_inv_value_log

806:
807: PROCEDURE initialize_high_water_mark
808: IS
809: BEGIN
810: INSERT INTO opi_dbi_inv_value_log
811: (
812: organization_id,
813: transaction_id,
814: transaction_date,

Line 841: tabname => 'OPI_DBI_INV_VALUE_LOG',

837: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' high water mark log rows inserted.');
838:
839: fnd_stats.gather_table_stats(
840: ownname => g_opi_schema,
841: tabname => 'OPI_DBI_INV_VALUE_LOG',
842: percent => 10);
843:
844: COMMIT;
845: