DBA Data[Home] [Help]

APPS.CTO_WORKFLOW dependencies on OE_TRANSACTION_TYPES_ALL

Line 2401: oe_transaction_types_all ota,

2397: into lReserveId
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

Line 2489: oe_transaction_types_all ota,

2485: into lRsvCount
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

Line 4449: oe_transaction_types_all ota,

4445: into lWipEntityId
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