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 528: ,wms_strategies_b wsb

524: SELECT wsm.rule_id
525: ,wsm.partial_success_allowed_flag
526: ,NVL(wsb.over_allocation_mode, 1) ,wsb.tolerance_value
527: FROM wms_strategy_members wsm
528: ,wms_strategies_b wsb
529: ,wms_rules_b wrb
530: WHERE wsm.strategy_id = p_strategy_id
531: AND wsb.strategy_id = p_strategy_id
532: AND wrb.rule_id = wsm.rule_id

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

1282: ||l_table_alias||'.date_type_from, '
1283: ||l_table_alias||'.date_type_to, '
1284: ||l_table_alias||'.effective_from, '
1285: ||l_table_alias||'.effective_to) = ''Y'' '
1286: ||' and (select wsbxyz.enabled_flag from wms_strategies_b wsbxyz where '
1287: ||l_table_alias||'.strategy_id = wsbxyz.strategy_id) = ''Y'' ';
1288:
1289: --add order by for sequence number
1290: l_order_by := 'order by '

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

1868: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
1869: -- and parameters p_transaction_temp_id and p_type_code
1870: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and
1871: -- WMS_TRANSACTIONS_TEMP )
1872: -- strategy record in WMS_STRATEGIES_B uniquely identified by
1873: -- parameter p_strategy_id
1874: -- at least one strategy member record in
1875: -- WMS_STRATEGY_MEMBERS identified by parameter
1876: -- p_strategy_id