Skip to main content

Oracle WMS Rules Query


/*********************
WMS Rules Extract
*********************/

select
mp.organization_code, c.rule_type, c.sequence_number, c.return_type, c.return_type_id, c.enabled_flag, 
c.transaction_action_name, c.TRANSACTION_SOURCE_TYPE_NAME, c.wms_enabled_flag, c.LAST_UPDATE_DATE, c.LAST_UPDATED_BY,
s.strategy_id, s.name, s.description, s.user_defined_flag, s.created_by, s.over_allocation_mode,
m.sequence_number,  m.rule_id, m.rule_name, m.partial_success_allowed_flag, m.LAST_UPDATED_BY, m.LAST_UPDATE_DATE,
r.sequence_number, r.logical_operator_meaning, r.bracket_open, r.left_object_name,  r.left_parameter_name, 
r.operator_meaning,
r.operand_type_meaning, r.operand_constant_character, r.operand_expression, r.right_parameter_name,
r.bracket_close, r.last_updated_by, r.last_update_date

from
apps.WMS_SELECTION_CRITERIA_TXN_V c,
apps.WMS_STRATEGIES_V s,
apps.WMS_STRATEGY_MEMBERS_V m,
apps.WMS_RESTRICTIONS_V r ,
apps.mtl_parameters mp

where 1=1 
and c.from_organization_id = mp.organization_id
and mp.organization_code in ('SGD')
and s.strategy_id = c.RETURN_TYPE_ID
and m.strategy_id = c.RETURN_TYPE_ID
and m.rule_id = r.rule_id
and c.enabled_flag = 1
--and c.rule_type = 'PICK'
order by c.from_organization_id, c.rule_type, c.sequence_number, m.sequence_number, r.SEQUENCE_NUMBER
;

Comments

Post a Comment

Popular posts from this blog

Oracle WMS Outbound Query

/*  ************************************************************************************************************          OUTBOUND METRICS           Released to Warehouse --> Staged/Pick Confirmed      ************************************************************************************************************  */  SELECT mp.organization_code "Warehouse", wda.delivery_id "Delivery", wt.name "Trip", (SELECT MEANING FROM apps.FND_LOOKUP_VALUES_VL WHERE lookup_type = 'PICK_STATUS' AND LOOKUP_CODE = wdd.released_status) "Delivery Status", CASE  WHEN wdt_extra.move_order_line_id IS NOT NULL THEN (SELECT MEANING FROM apps.FND_LOOKUP_VALUES_VL WHERE lookup_type = 'WMS_TASK_STATUS' AND LOOKUP_CODE = wdt_extra.status)  WHEN mmtt.wms_task_status IS NOT NULL THEN (SELECT MEANING FROM apps.FND_LOOKUP_VALUES_VL WHERE lookup_type = 'WMS_TASK_STATUS' AND LOOKUP_CODE = mmtt.wms_task_status) ...
Post a Comment
Read more

Oracle WMS Tasks Query

SELECT *   FROM (SELECT wdth.transaction_temp_id,                wdth.task_id,                oeh.order_number,                oel.line_number,                msi.concatenated_segments item_number,                'Pick',                'Completed',                fu1.user_name             assigned_to,                wdth.person_id,                mmtt.transaction_quantity,                mmtt.transaction_uom           FROM apps.oe_order_headers_all         oeh,         ...
Post a Comment
Read more

OracleApps OM Query

-- Order Details select --* ol.line_id, --oh.sold_to_org_id, oh.created_by, (select user_name from apps.fnd_user where user_id = oh.created_by) created_name, c.account_number, d.party_name "Cust Name", --oh.ship_to_org_id, oh.invoice_to_org_id, hl1.country "ShipCountry",hcas1.attribute17, hl2.country "BillCountry",hcas2.attribute17, oh.transactional_curr_code curr, oh.org_id, (select name from apps.hr_operating_units where organization_id = oh.org_id) "OU", oh.order_number, --oh.header_id, oh.creation_date, tt.name "OrderType", --oh.order_source_id,   oh.open_flag, oh.booked_flag,   oh.CUST_PO_NUMBER, --oh.shipping_method_code, (select wcsv.ship_method_meaning from apps.WSH_CARRIER_SERVICES_V wcsv where wcsv.ship_method_code = oh.shipping_method_code) HEADER_SHIP_METHOD, --ol.line_id, ol.line_number||'.'||ol.shipment_number "line", ol.ordered_item, --msieb.C_EXT_ATTR26 APC_WM_ST...
Post a Comment
Read more