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_RULE_PVT dependencies on MTL_PARAMETERS

Line 391: ,MTL_PARAMETERS mp

387: ,mil.PROJECT_ID PROJECT_ID
388: ,mil.TASK_ID TASK_ID
389: from MTL_ITEM_LOCATIONS mil
390: ,MTL_SECONDARY_INVENTORIES msei
391: ,MTL_PARAMETERS mp
392: ,MTL_SYSTEM_ITEMS msi
393: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 2
394: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 2
395: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 418: ,MTL_PARAMETERS mp

414: ,mil.TASK_ID
415: from MTL_ITEM_LOCATIONS mil
416: ,MTL_SECONDARY_INVENTORIES msei
417: ,MTL_ITEM_SUB_INVENTORIES misi
418: ,MTL_PARAMETERS mp
419: ,MTL_SYSTEM_ITEMS msi
420: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 1
421: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 2
422: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 449: ,MTL_PARAMETERS mp

445: from MTL_ITEM_LOCATIONS mil
446: ,MTL_SECONDARY_LOCATORS msl
447: ,MTL_SECONDARY_INVENTORIES msei
448: ,MTL_ITEM_SUB_INVENTORIES misi
449: ,MTL_PARAMETERS mp
450: ,MTL_SYSTEM_ITEMS msi
451: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 1
452: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 1
453: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID

Line 2996: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '

2992: -- # 6917190
2993: -- 7280339 added check for status_id is null
2994: g_input_where := g_input_where
2995: || ' and '
2996: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '
2997: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
2998: || g_base_table_alias
2999: || '.STATUS_ID'
3000: || ' AND RESERVABLE_TYPE = 1)) OR '

Line 3001: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '

2997: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
2998: || g_base_table_alias
2999: || '.STATUS_ID'
3000: || ' AND RESERVABLE_TYPE = 1)) OR '
3001: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '
3002: || ' or '
3003: || g_base_table_alias
3004: || '.STATUS_ID IS NULL)'
3005: || ' and '

Line 3023: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '

3019: -- Bug 6719290, 6917190
3020: IF l_is_mat_status_used = 1 THEN
3021: g_input_where := g_input_where
3022: || ' and '
3023: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '
3024: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3025: || g_base_table_alias
3026: || '.STATUS_ID'
3027: || ' AND RESERVABLE_TYPE = 1)) OR '

Line 3028: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '

3024: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3025: || g_base_table_alias
3026: || '.STATUS_ID'
3027: || ' AND RESERVABLE_TYPE = 1)) OR '
3028: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '
3029: || 'or '
3030: || g_base_table_alias
3031: || '.STATUS_ID IS NULL)'
3032: || ' and '

Line 3063: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '

3059: -- Bug 6719290, 6917190
3060: IF l_is_mat_status_used = 1 THEN
3061: g_input_where := g_input_where
3062: || ' and '
3063: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '
3064: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3065: || g_base_table_alias
3066: || '.STATUS_ID'
3067: || ' AND RESERVABLE_TYPE = 1)) OR '

Line 3068: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '

3064: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3065: || g_base_table_alias
3066: || '.STATUS_ID'
3067: || ' AND RESERVABLE_TYPE = 1)) OR '
3068: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '
3069: || 'or '
3070: || g_base_table_alias
3071: || '.STATUS_ID IS NULL)'
3072: || ' and '

Line 6427: from mtl_parameters

6423: retval := inv_cache.set_org_rec(g_locator.organization_id);
6424: /*
6425: select *
6426: into l_org
6427: from mtl_parameters
6428: where organization_id = l_locator.organization_id;
6429: */
6430: retval := inv_cache.set_tosub_rec(g_locator.organization_id, g_locator.subinventory_code);
6431: /* select *

Line 6714: --cursor to get default rule ids from mtl_parameters table

6710: l_onhand_status_trx_allowed VARCHAR2(1);
6711: l_default_status_id NUMBER ;
6712: -- LPN Status Project
6713:
6714: --cursor to get default rule ids from mtl_parameters table
6715: CURSOR l_default_rules IS
6716: SELECT default_wms_picking_rule_id
6717: , default_put_away_rule_id
6718: , rules_override_lot_reservation

Line 6719: FROM mtl_parameters

6715: CURSOR l_default_rules IS
6716: SELECT default_wms_picking_rule_id
6717: , default_put_away_rule_id
6718: , rules_override_lot_reservation
6719: FROM mtl_parameters
6720: WHERE organization_id = p_organization_id;
6721:
6722: --cursor used to determine if item is lot controlled
6723: CURSOR l_cur_serial IS

Line 7354: * from the mtl_parameters, allocate directly if res is fully detailed.

7350: END IF;
7351:
7352:
7353: /* LG. Check the txn dtl lines with the control flags, then check the override rule flag
7354: * from the mtl_parameters, allocate directly if res is fully detailed.
7355: */
7356: --[
7357: -- If the Serial Number is reserved, Rules are not called and following code is called
7358: --]

Line 13864: FROM mtl_parameters mp

13860: -- "Locator and LPN Based Consolidation in Staging Lane" seeded outbound operation plan
13861: -- for the MMTT records associated with the move order header.
13862: UPDATE mtl_material_transactions_temp mmtt
13863: SET mmtt.operation_plan_id = (SELECT NVL(default_pick_op_plan_id, 1)
13864: FROM mtl_parameters mp
13865: WHERE mp.organization_id = mmtt.organization_id)
13866: WHERE mmtt.operation_plan_id IS NULL
13867: AND mmtt.move_order_line_id IN (SELECT line_id
13868: FROM mtl_txn_request_lines mol

Line 13952: FROM mtl_parameters

13948: -- Bug# 4587423: If a default outbound operation plan is not defined for the org,
13949: -- default to 1 (Locator and LPN Based Consolidation in Staging Lane)
13950: CURSOR c_default_operation_plan IS
13951: SELECT NVL(default_pick_op_plan_id, 1)
13952: FROM mtl_parameters
13953: WHERE organization_id = l_organization_id;
13954:
13955: l_rule_counter INTEGER;
13956: BEGIN

Line 14202: FROM mtl_parameters mp WHERE mp.organization_id = mmtt.organization_id)

14198: 4, default_repl_task_type_id,
14199: 5, default_moxfer_task_type_id,
14200: 6, default_moissue_task_type_id,
14201: NULL)
14202: FROM mtl_parameters mp WHERE mp.organization_id = mmtt.organization_id)
14203: WHERE mmtt.standard_operation_id IS NULL
14204: AND mmtt.move_order_line_id IN (SELECT line_id
14205: FROM mtl_txn_request_lines mol
14206: WHERE mol.header_id = p_move_order_header_id);

Line 14316: FROM mtl_parameters

14312: SELECT default_pick_task_type_id
14313: ,default_cc_task_type_id
14314: ,default_putaway_task_type_id
14315: ,default_repl_task_type_id
14316: FROM mtl_parameters
14317: WHERE organization_id = l_organization_id;
14318: */
14319:
14320: CURSOR c_default_task_type IS

Line 14328: FROM mtl_parameters

14324: , default_repl_task_type_id
14325: , default_moxfer_task_type_id
14326: , default_moissue_task_type_id
14327: , default_pick_op_plan_id
14328: FROM mtl_parameters
14329: WHERE organization_id = l_organization_id;
14330:
14331: l_rule_counter INTEGER;
14332: BEGIN

Line 15858: --cursor to get default rule ids from mtl_parameters table

15854: l_progress VARCHAR2(10); -- local variable to track program progress,
15855: -- especially useful when exception occurs
15856:
15857:
15858: --cursor to get default rule ids from mtl_parameters table
15859: CURSOR l_default_rules IS
15860: SELECT default_wms_picking_rule_id
15861: , default_put_away_rule_id
15862: FROM mtl_parameters

Line 15862: FROM mtl_parameters

15858: --cursor to get default rule ids from mtl_parameters table
15859: CURSOR l_default_rules IS
15860: SELECT default_wms_picking_rule_id
15861: , default_put_away_rule_id
15862: FROM mtl_parameters
15863: WHERE organization_id = p_organization_id;
15864:
15865: --cursor used to determine if item is lot controlled
15866: CURSOR l_cur_serial IS