DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on OE_TRANSACTION_TYPES_TL

Line 693: oe_transaction_types_tl otl,

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

Line 752: oe_transaction_types_tl otl,

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

Line 864: oe_transaction_types_tl otl,

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

Line 995: oe_transaction_types_tl oet,

991: lOrgId, --ship from org id
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'