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_INIT_PKG dependencies on OPI_DBI_INV_TYPE_CODES

Line 197: -- Note: OPI_DBI_INV_TYPE_CODES is not cleaned anywhere.

193: -- OPI_DBI_CONVERSION_RATES
194: -- OPI_DBI_INV_ITEM_COSTS_TMP
195: -- OPI_PMI_COST_PARAM_GTMP
196: -- OPI_DBI_INV_VALUE_LOG -- added as part of CPCS Change.
197: -- Note: OPI_DBI_INV_TYPE_CODES is not cleaned anywhere.
198: -- Intransit Tables:
199: -- OPI_DBI_INTR_SUP_TMP
200: -- OPI_DBI_INTR_MMT_TMP
201: -- OPI_DBI_INTR_MIP_TMP

Line 2769: -- This procedure is used to insert data into OPI_DBI_INV_TYPE_CODES which

2765:
2766: END RUN_DISCRETE_FIRST_ETL;
2767:
2768: -------------------------------------------------------------------------------
2769: -- This procedure is used to insert data into OPI_DBI_INV_TYPE_CODES which
2770: -- is apparently used in opi_inv_type_org_mv.
2771:
2772: PROCEDURE SEED_INV_TYPE_CODES
2773: IS

Line 2786: FROM OPI_DBI_INV_TYPE_CODES

2782:
2783: -- Cursor to check if the table is empty or not
2784: CURSOR type_code_exists_check_csr IS
2785: SELECT 1
2786: FROM OPI_DBI_INV_TYPE_CODES
2787: WHERE rownum < 2;
2788: --declared for bug 3429014
2789:
2790: BEGIN

Line 2813: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('ONH');

2809: END IF;
2810:
2811: IF (type_code_exists_check_csr%NOTFOUND) THEN
2812:
2813: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('ONH');
2814: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('INT');
2815: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('WIP');
2816:
2817: END IF;

Line 2814: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('INT');

2810:
2811: IF (type_code_exists_check_csr%NOTFOUND) THEN
2812:
2813: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('ONH');
2814: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('INT');
2815: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('WIP');
2816:
2817: END IF;
2818:

Line 2815: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('WIP');

2811: IF (type_code_exists_check_csr%NOTFOUND) THEN
2812:
2813: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('ONH');
2814: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('INT');
2815: INSERT INTO opi_dbi_inv_type_codes (inventory_type) VALUES ('WIP');
2816:
2817: END IF;
2818:
2819: l_stmt_num := 30;