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_RES_PKG dependencies on WIP_TRANSACTION_ACCOUNTS

Line 799: wip_transaction_accounts wta,

795: nvl( wta.repetitive_schedule_id, wta.wip_entity_id ) job_id,
796: Decode(we.entity_type, 1, 1, 2, 2, 3, 1, 4, 3, 5, 5, 8, 5, 0) job_type,
797: wt.primary_item_id assembly_item_id
798: FROM wip_transactions wt,
799: wip_transaction_accounts wta,
800: wip_entities we,
801: mtl_uom_conversions m,
802: mtl_uom_conversions m2,
803: opi_dbi_run_log_curr rlc,

Line 1091: index(wt, WIP_TRANSACTIONS_U1) index(wta, WIP_TRANSACTION_ACCOUNTS_N1)

1087: job_id,
1088: job_type,
1089: assembly_item_id)
1090: SELECT /*+ ordered use_nl(rlc wt) index(rlc, OPI_DBI_RUN_LOG_CURR_N1)
1091: index(wt, WIP_TRANSACTIONS_U1) index(wta, WIP_TRANSACTION_ACCOUNTS_N1)
1092: use_nl(we) index(we, WE_C1) index(bdr, BOM_DEPARTMENT_RESOURCES_U1)
1093: use_nl(bdr) use_nl(m) use_nl(m2) */
1094: wt.resource_id,
1095: nvl(bdr.share_from_dept_id, wt.department_id ),

Line 1110: wip_transaction_accounts wta,

1106: nvl( wta.repetitive_schedule_id, wta.wip_entity_id ) job_id,
1107: Decode(we.entity_type, 1, 1, 2, 2, 3, 1, 4, 3, 5, 5, 8, 5, 0) job_type,
1108: wt.primary_item_id assembly_item_id
1109: FROM wip_transactions wt,
1110: wip_transaction_accounts wta,
1111: wip_entities we,
1112: opi_dbi_run_log_curr rlc,
1113: bom_department_resources bdr,
1114: mtl_uom_conversions m,