DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_SALES_ORDERS

Line 769: mtl_sales_orders mso

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
773: and oeh.order_type_id = ota.transaction_type_id

Line 828: mtl_sales_orders mso

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
832: and oeh.order_type_id = ota.transaction_type_id

Line 940: mtl_sales_orders mso

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
944: and oeh.order_type_id = ota.transaction_type_id

Line 1075: mtl_sales_orders mso,

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