DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on OE_TRANSACTION_TYPES_TL

Line 1244: oe_transaction_types_tl ott

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
1247: AND TO_CHAR(ooh.order_number) = mso.segment1
1248: AND ooh.order_type_id = ott.transaction_type_id

Line 2316: oe_transaction_types_tl ott

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
2319: AND to_char(ooh.order_number) = mkts.segment1
2320: AND ooh.order_type_id = ott.transaction_type_id

Line 3300: oe_transaction_types_tl ott

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
3303: AND TO_CHAR(ooh.order_number) = mso.segment1
3304: AND ooh.order_type_id = ott.transaction_type_id