DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_SALES_ORDERS

Line 694: mtl_sales_orders mso

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
697: and oeh.header_id = oel.header_id
698: and oeh.order_type_id = ota.transaction_type_id

Line 753: mtl_sales_orders mso

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
756: and oeh.header_id = oel.header_id
757: and oeh.order_type_id = ota.transaction_type_id

Line 865: mtl_sales_orders mso

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
868: and oeh.header_id = oel.header_id
869: and oeh.order_type_id = ota.transaction_type_id

Line 996: mtl_sales_orders mso,

992: lHeaderId -- header id in oeh, for wip api
993: from oe_order_lines_all oel,
994: oe_order_headers_all oeh,
995: oe_transaction_types_tl oet,
996: mtl_sales_orders mso,
997: mtl_system_items msi
998: where oel.line_id = lConfigLineId
999: and item_type_code = 'CONFIG'
1000: and oeh.header_id = oel.header_id