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

Line 787: oe_order_lines_all ool,

783: cce.parent_event_id prior_event_id,
784: cce.cogs_percentage cogs_percentage,
785: sum(cce.event_quantity) prior_event_quantity
786: FROM mtl_material_transactions mmt,
787: oe_order_lines_all ool,
788: cst_revenue_cogs_match_lines crcml,
789: cst_cogs_events cce,
790: mtl_secondary_inventories msi,
791: mtl_system_items_b item

Line 1242: oe_order_lines_all ool,

1238: 1, -- Logical Txn
1239: ccqa.adj_new_cogs_percentage
1240: FROM cst_cogs_qty_adj_events_temp ccqa,
1241: mtl_sales_orders mso,
1242: oe_order_lines_all ool,
1243: oe_order_headers_all ooh,
1244: oe_transaction_types_tl ott
1245: WHERE ool.line_id = ccqa.adj_cogs_om_line_id
1246: AND ool.header_id = ooh.header_id

Line 2314: oe_order_lines_all ool,

2310: UPDATE mtl_cogs_recognition_temp mcr
2311: SET (transaction_source_id) = (
2312: SELECT mkts.sales_order_id
2313: FROM mtl_sales_orders mkts,
2314: oe_order_lines_all ool,
2315: oe_order_headers_all ooh,
2316: oe_transaction_types_tl ott
2317: WHERE ool.line_id = mcr.trx_source_line_id
2318: AND ool.header_id = ooh.header_id

Line 3298: oe_order_lines_all ool,

3294: 1, -- Logical Txn
3295: ccqa.adj_new_cogs_percentage
3296: FROM cst_cogs_qty_adj_events_temp ccqa,
3297: mtl_sales_orders mso,
3298: oe_order_lines_all ool,
3299: oe_order_headers_all ooh,
3300: oe_transaction_types_tl ott
3301: WHERE ool.line_id = ccqa.adj_cogs_om_line_id
3302: AND ool.header_id = ooh.header_id

Line 5971: OE_ORDER_LINES_ALL OOL,

5967: FROM
5968: CST_REVENUE_COGS_MATCH_LINES CRCML,
5969: CST_COGS_EVENTS CCE,
5970: GL_PERIOD_STATUSES GPS,
5971: OE_ORDER_LINES_ALL OOL,
5972: OE_ORDER_HEADERS_ALL OOH,
5973: MTL_TRANSACTION_ACCOUNTS MTA
5974: WHERE
5975: CRCML.SALES_ORDER_ISSUE_DATE BETWEEN :i_sales_order_date_low AND :i_sales_order_date_high

Line 6181: OE_ORDER_LINES_ALL OOL,

6177: sum(decode(CAL.ae_line_type_code, 36, nvl(CAL.accounted_dr,0) - nvl(CAL.accounted_cr,0),0)) DEF_COGS_BALANCE
6178: FROM
6179: CST_REVENUE_COGS_MATCH_LINES CRCML,
6180: CST_COGS_EVENTS CCE,
6181: OE_ORDER_LINES_ALL OOL,
6182: OE_ORDER_HEADERS_ALL OOH,
6183: CST_COST_GROUP_ASSIGNMENTS CCGA,
6184: CST_PAC_PERIODS CPP,
6185: CST_AE_HEADERS CAH,