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 WIP_ENTITIES

Line 2152: ,wip_entities we

2148: end push_to_fact_flag,
2149: 'MTA' transaction_source
2150: FROM mtl_transaction_accounts mta
2151: ,mtl_material_transactions mmt
2152: ,wip_entities we
2153: ,opi_dbi_conc_prog_run_log prl
2154: WHERE prl.driving_table_code = 'MMT'
2155: AND prl.etl_type = 'INVENTORY'
2156: AND prl.load_type = 'INIT'

Line 2165: -- in case of transaction source type id is 5 then join with wip entities table to get the wip assembly id

2161: -- changing bound to MTA bug 4576545
2162: AND mmt.transaction_date >= g_global_start_date -- to avoid any backdated transactions
2163: AND mmt.transaction_id = mta.transaction_id
2164: AND mta.accounting_line_type in (1,7)
2165: -- in case of transaction source type id is 5 then join with wip entities table to get the wip assembly id
2166: AND decode(mta.accounting_line_type,7,mta.transaction_source_id,null) = we.wip_entity_id(+)
2167: GROUP BY
2168: mta.organization_id,
2169: decode(mmt.transaction_action_id,

Line 2302: wip_entities we,

2298: 1 source,
2299: 'Y' push_to_fact_flag,
2300: 'WTA' transaction_source
2301: FROM wip_transaction_accounts wta,
2302: wip_entities we,
2303: opi_dbi_conc_prog_run_log prl
2304: WHERE prl.etl_type = 'INVENTORY'
2305: AND prl.driving_table_code = 'WTA'
2306: AND prl.load_type = 'INIT'

Line 2359: wip_entities we

2355: 1,
2356: 'N',
2357: 'WPB' transaction_source
2358: FROM wip_period_balances wpb,
2359: wip_entities we
2360: WHERE wpb.wip_entity_id = we.wip_entity_id
2361: AND we.entity_type in (1, 2, 3, 4, 5, 8)
2362: AND we.primary_item_id IS NOT NULL
2363: GROUP BY