DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on OE_TRANSACTION_TYPES_TL

Line 1425: oe_transaction_types_tl ott

1421: FROM cst_cogs_qty_adj_events_temp ccqa,
1422: mtl_sales_orders mso,
1423: oe_order_lines_all ool,
1424: oe_order_headers_all ooh,
1425: oe_transaction_types_tl ott
1426: WHERE ool.line_id = ccqa.adj_cogs_om_line_id
1427: AND ool.header_id = ooh.header_id
1428: AND TO_CHAR(ooh.order_number) = mso.segment1
1429: AND ooh.order_type_id = ott.transaction_type_id

Line 2364: oe_transaction_types_tl ott

2360: SELECT mkts.sales_order_id, mkts.segment1
2361: FROM mtl_sales_orders mkts,
2362: oe_order_lines_all ool,
2363: oe_order_headers_all ooh,
2364: oe_transaction_types_tl ott
2365: WHERE ool.line_id = mcr.trx_source_line_id
2366: AND ool.header_id = ooh.header_id
2367: AND to_char(ooh.order_number) = mkts.segment1
2368: AND ooh.order_type_id = ott.transaction_type_id

Line 3326: oe_transaction_types_tl ott

3322: FROM cst_cogs_qty_adj_events_temp ccqa,
3323: mtl_sales_orders mso,
3324: oe_order_lines_all ool,
3325: oe_order_headers_all ooh,
3326: oe_transaction_types_tl ott
3327: WHERE ool.line_id = ccqa.adj_cogs_om_line_id
3328: AND ool.header_id = ooh.header_id
3329: AND TO_CHAR(ooh.order_number) = mso.segment1
3330: AND ooh.order_type_id = ott.transaction_type_id