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.FLM_MMM_CALCULATION dependencies on OE_ORDER_LINES_ALL

Line 174: OE_ORDER_LINES_ALL SL1,

170: SELECT distinct
171: sl1.inventory_item_id item_id,
172: wl.line_id
173: FROM
174: OE_ORDER_LINES_ALL SL1,
175: MTL_SYSTEM_ITEMS_KFV MSI1,
176: WIP_LINES WL,
177: (select sl2.line_id,
178: decode((select 1

Line 195: from oe_order_lines_all sl2) line_holds,

191: mrp_flow_schedule_util.check_holds(sl2.header_id,
192: sl2.line_id,
193: null,
194: null))) hold
195: from oe_order_lines_all sl2) line_holds,
196: (select sl2.line_id,
197: CTO_WIP_WORKFLOW_API_PK.workflow_build_status(sl2.LINE_ID) status
198: from oe_order_lines_all sl2) line_build
199: WHERE

Line 198: from oe_order_lines_all sl2) line_build

194: null))) hold
195: from oe_order_lines_all sl2) line_holds,
196: (select sl2.line_id,
197: CTO_WIP_WORKFLOW_API_PK.workflow_build_status(sl2.LINE_ID) status
198: from oe_order_lines_all sl2) line_build
199: WHERE
200: line_build.line_id = sl1.line_id
201: AND 1 = decode(MSI1.REPLENISH_TO_ORDER_FLAG, 'N', 1, line_build.status)
202: AND MSI1.BUILD_IN_WIP_FLAG = 'Y'