Query to extract modifiers have been applied to a particular sales order
oracle-ebs-modifier-applied-against-so SELECT a.NAME “Modifier Name”,b.INVENTORY_ITEM_ID, b.list_line_no “Modifier Line No”, a.description “Modifier Description”, a.comments, b.list_line_type_code, d.qualifier_context, a.orig_org_id, a.active_flag, b.start_date_active, b.end_date_active, a.list_type_code, b.modifier_level_code, b.organization_id, f.order_number, b.pricing_phase_id, b.last_update_date, b.list_line_no, d.header_quals_exist_flag, d.qualifier_datatype, d.qualifier_attribute, d.segment_id,…
Read More