DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on OE_TRANSACTION_TYPES_ALL

Line 767: oe_transaction_types_all ota,

763: into lWipEntityId
764: from wip_flow_schedules wfs,
765: oe_order_lines_all oel,
766: oe_order_headers_all oeh,
767: oe_transaction_types_all ota,
768: oe_transaction_types_tl otl,
769: mtl_sales_orders mso
770: where wfs.demand_source_line = oel.line_id --config line id
771: and oel.line_id = pLineId

Line 826: oe_transaction_types_all ota,

822: into lReserveId
823: from mtl_reservations mr,
824: oe_order_lines_all oel,
825: oe_order_headers_all oeh,
826: oe_transaction_types_all ota,
827: oe_transaction_types_tl otl,
828: mtl_sales_orders mso
829: where mr.demand_source_line_id = oel.line_id --config line id
830: and oel.line_id = pLineId

Line 938: oe_transaction_types_all ota,

934: select distinct reservation_id
935: from mtl_reservations mr,
936: oe_order_lines_all oel,
937: oe_order_headers_all oeh,
938: oe_transaction_types_all ota,
939: oe_transaction_types_tl otl,
940: mtl_sales_orders mso
941: where mr.demand_source_line_id = oel.line_id --config line id
942: and oel.line_id = lConfigLineId