Friday, November 26, 2021

OE_ORDER_LINES_ALL.source_document_type_id in Oracle APPS

SELECT order_source_id, name, description 
FROM oe_order_sources

Here order_source_id will be source_document_type_id  in OE_ORDER_LINES_ALL table.


No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...