DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on OE_TRANSACTION_TYPES_TL

Line 768: oe_transaction_types_tl otl,

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
772: and oeh.header_id = oel.header_id

Line 827: oe_transaction_types_tl otl,

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
831: and oeh.header_id = oel.header_id

Line 939: oe_transaction_types_tl otl,

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
943: and oeh.header_id = oel.header_id

Line 1074: oe_transaction_types_tl oet,

1070: lOrgId, --ship from org id
1071: lHeaderId -- header id in oeh, for wip api
1072: from oe_order_lines_all oel,
1073: oe_order_headers_all oeh,
1074: oe_transaction_types_tl oet,
1075: mtl_sales_orders mso,
1076: mtl_system_items msi
1077: where oel.line_id = lConfigLineId
1078: and item_type_code = 'CONFIG'