eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_STRATEGY_PVT dependencies on WMS_STRATEGIES_B

Line 516: ,wms_strategies_b wsb

512: SELECT wsm.rule_id
513: ,wsm.partial_success_allowed_flag
514: ,NVL(wsb.over_allocation_mode, 1) ,wsb.tolerance_value
515: FROM wms_strategy_members wsm
516: ,wms_strategies_b wsb
517: ,wms_rules_b wrb
518: WHERE wsm.strategy_id = p_strategy_id
519: AND wsb.strategy_id = p_strategy_id
520: AND wrb.rule_id = wsm.rule_id

Line 1248: ||' and (select wsbxyz.enabled_flag from wms_strategies_b wsbxyz where '

1244: ||l_table_alias||'.date_type_from, '
1245: ||l_table_alias||'.date_type_to, '
1246: ||l_table_alias||'.effective_from, '
1247: ||l_table_alias||'.effective_to) = ''Y'' '
1248: ||' and (select wsbxyz.enabled_flag from wms_strategies_b wsbxyz where '
1249: ||l_table_alias||'.strategy_id = wsbxyz.strategy_id) = ''Y'' ';
1250:
1251: --add order by for sequence number
1252: l_order_by := 'order by '

Line 1717: -- strategy record in WMS_STRATEGIES_B uniquely identified by

1713: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
1714: -- and parameters p_transaction_temp_id and p_type_code
1715: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and
1716: -- WMS_TRANSACTIONS_TEMP )
1717: -- strategy record in WMS_STRATEGIES_B uniquely identified by
1718: -- parameter p_strategy_id
1719: -- at least one strategy member record in
1720: -- WMS_STRATEGY_MEMBERS identified by parameter
1721: -- p_strategy_id