DBA Data[Home] [Help]

APPS.CTO_WORKFLOW dependencies on OE_TRANSACTION_TYPES_TL

Line 2435: oe_transaction_types_tl otl,

2431: from mtl_reservations mr,
2432: oe_order_lines_all oel,
2433: oe_order_headers_all oeh,
2434: oe_transaction_types_all ota,
2435: oe_transaction_types_tl otl,
2436: mtl_sales_orders mso
2437: where mr.demand_source_line_id = oel.line_id --ato item line id
2438: and oel.line_id = pLineId
2439: and oeh.header_id = oel.header_id

Line 2523: oe_transaction_types_tl otl,

2519: from mtl_reservations mr,
2520: oe_order_lines_all oel,
2521: oe_order_headers_all oeh,
2522: oe_transaction_types_all ota,
2523: oe_transaction_types_tl otl,
2524: mtl_sales_orders mso
2525: where mr.demand_source_line_id = oel.line_id --ato item line id
2526: and oel.line_id = pLineId
2527: and oeh.header_id = oel.header_id

Line 4549: oe_transaction_types_tl otl,

4545: from wip_flow_schedules wfs,
4546: oe_order_lines_all oel,
4547: oe_order_headers_all oeh,
4548: oe_transaction_types_all ota,
4549: oe_transaction_types_tl otl,
4550: mtl_sales_orders mso
4551: where wfs.demand_source_line = to_char(pLineId) --config line id
4552: and oel.line_id = pLineId
4553: and oeh.header_id = oel.header_id