DBA Data[Home] [Help]

APPS.CTO_WORKFLOW dependencies on OE_TRANSACTION_TYPES_TL

Line 2402: oe_transaction_types_tl otl,

2398: from mtl_reservations mr,
2399: oe_order_lines_all oel,
2400: oe_order_headers_all oeh,
2401: oe_transaction_types_all ota,
2402: oe_transaction_types_tl otl,
2403: mtl_sales_orders mso
2404: where mr.demand_source_line_id = oel.line_id --ato item line id
2405: and oel.line_id = pLineId
2406: and oeh.header_id = oel.header_id

Line 2490: oe_transaction_types_tl otl,

2486: from mtl_reservations mr,
2487: oe_order_lines_all oel,
2488: oe_order_headers_all oeh,
2489: oe_transaction_types_all ota,
2490: oe_transaction_types_tl otl,
2491: mtl_sales_orders mso
2492: where mr.demand_source_line_id = oel.line_id --ato item line id
2493: and oel.line_id = pLineId
2494: and oeh.header_id = oel.header_id

Line 4450: oe_transaction_types_tl otl,

4446: from wip_flow_schedules wfs,
4447: oe_order_lines_all oel,
4448: oe_order_headers_all oeh,
4449: oe_transaction_types_all ota,
4450: oe_transaction_types_tl otl,
4451: mtl_sales_orders mso
4452: where wfs.demand_source_line = to_char(pLineId) --config line id
4453: and oel.line_id = pLineId
4454: and oeh.header_id = oel.header_id