DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on OE_TRANSACTION_TYPES_ALL

Line 692: oe_transaction_types_all ota,

688: into lWipEntityId
689: from wip_flow_schedules wfs,
690: oe_order_lines_all oel,
691: oe_order_headers_all oeh,
692: oe_transaction_types_all ota,
693: oe_transaction_types_tl otl,
694: mtl_sales_orders mso
695: where wfs.demand_source_line = oel.line_id --config line id
696: and oel.line_id = pLineId

Line 751: oe_transaction_types_all ota,

747: into lReserveId
748: from mtl_reservations mr,
749: oe_order_lines_all oel,
750: oe_order_headers_all oeh,
751: oe_transaction_types_all ota,
752: oe_transaction_types_tl otl,
753: mtl_sales_orders mso
754: where mr.demand_source_line_id = oel.line_id --config line id
755: and oel.line_id = pLineId

Line 863: oe_transaction_types_all ota,

859: select distinct reservation_id
860: from mtl_reservations mr,
861: oe_order_lines_all oel,
862: oe_order_headers_all oeh,
863: oe_transaction_types_all ota,
864: oe_transaction_types_tl otl,
865: mtl_sales_orders mso
866: where mr.demand_source_line_id = oel.line_id --config line id
867: and oel.line_id = lConfigLineId