DBA Data[Home] [Help]

APPS.CTO_WORKFLOW dependencies on OE_TRANSACTION_TYPES_ALL

Line 2434: oe_transaction_types_all ota,

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

Line 2522: oe_transaction_types_all ota,

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

Line 4548: oe_transaction_types_all ota,

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