[Home] [Help]
407: ,mil.PROJECT_ID PROJECT_ID
408: ,mil.TASK_ID TASK_ID
409: from MTL_ITEM_LOCATIONS mil
410: ,MTL_SECONDARY_INVENTORIES msei
411: ,MTL_PARAMETERS mp
412: ,MTL_SYSTEM_ITEMS msi
413: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 2
414: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 2
415: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
434: ,mil.TASK_ID
435: from MTL_ITEM_LOCATIONS mil
436: ,MTL_SECONDARY_INVENTORIES msei
437: ,MTL_ITEM_SUB_INVENTORIES misi
438: ,MTL_PARAMETERS mp
439: ,MTL_SYSTEM_ITEMS msi
440: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 1
441: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 2
442: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
465: from MTL_ITEM_LOCATIONS mil
466: ,MTL_SECONDARY_LOCATORS msl
467: ,MTL_SECONDARY_INVENTORIES msei
468: ,MTL_ITEM_SUB_INVENTORIES misi
469: ,MTL_PARAMETERS mp
470: ,MTL_SYSTEM_ITEMS msi
471: where nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) = 1
472: and nvl(msi.RESTRICT_LOCATORS_CODE,2) = 1
473: and mp.ORGANIZATION_ID = msi.ORGANIZATION_ID
3323: -- high volume project 8546026
3324: IF l_is_mat_status_used = 1 THEN
3325: g_input_where := g_input_where
3326: || ' and '
3327: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '
3328: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3329: || g_base_table_alias
3330: || '.STATUS_ID'
3331: || ' AND RESERVABLE_TYPE = 1)) OR '
3328: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3329: || g_base_table_alias
3330: || '.STATUS_ID'
3331: || ' AND RESERVABLE_TYPE = 1)) OR '
3332: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '
3333: || ' or '
3334: || g_base_table_alias
3335: || '.STATUS_ID IS NULL)'
3336: || ' and '
3361: -- Bug 6719290, 6917190
3362: IF l_is_mat_status_used = 1 THEN
3363: g_input_where := g_input_where
3364: || ' and '
3365: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '
3366: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3367: || g_base_table_alias
3368: || '.STATUS_ID'
3369: || ' AND RESERVABLE_TYPE = 1)) OR '
3366: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3367: || g_base_table_alias
3368: || '.STATUS_ID'
3369: || ' AND RESERVABLE_TYPE = 1)) OR '
3370: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '
3371: || 'or '
3372: || g_base_table_alias
3373: || '.STATUS_ID IS NULL)'
3374: || ' and '
3401: -- Bug 6719290, 6917190
3402: IF l_is_mat_status_used = 1 THEN
3403: g_input_where := g_input_where
3404: || ' and '
3405: || ' ((exists (select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not null ) '
3406: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3407: || g_base_table_alias
3408: || '.STATUS_ID'
3409: || ' AND RESERVABLE_TYPE = 1)) OR '
3406: || ' AND exists(select 1 from mtl_material_statuses where status_id = '
3407: || g_base_table_alias
3408: || '.STATUS_ID'
3409: || ' AND RESERVABLE_TYPE = 1)) OR '
3410: || '((NOT exists(select 1 from mtl_parameters where organization_id = g_organization_id and default_status_id is not NULL) '
3411: || 'or '
3412: || g_base_table_alias
3413: || '.STATUS_ID IS NULL)'
3414: || ' and '
8386: retval := inv_cache.set_org_rec(g_locator.organization_id);
8387: /*
8388: select *
8389: into l_org
8390: from mtl_parameters
8391: where organization_id = l_locator.organization_id;
8392: */
8393: retval := inv_cache.set_tosub_rec(g_locator.organization_id, g_locator.subinventory_code);
8394: /* select *
9287: l_sl_rsv_is_detailed := 'Y';
9288: END IF;
9289:
9290: /* LG. Check the txn dtl lines with the control flags, then check the override rule flag
9291: * from the mtl_parameters, allocate directly if res is fully detailed.
9292: */
9293: -- [
9294: -- If the Serial Number is reserved, Rules are not called and following code is called
9295: -- ]
16524: -- "Locator and LPN Based Consolidation in Staging Lane" seeded outbound operation plan
16525: -- for the MMTT records associated with the move order header.
16526: UPDATE mtl_material_transactions_temp mmtt
16527: SET mmtt.operation_plan_id = (SELECT NVL(default_pick_op_plan_id, 1)
16528: FROM mtl_parameters mp
16529: WHERE mp.organization_id = mmtt.organization_id)
16530: WHERE mmtt.operation_plan_id IS NULL
16531: AND mmtt.move_order_line_id IN (SELECT line_id
16532: FROM mtl_txn_request_lines mol
16606: -- Bug# 4587423: If a default outbound operation plan is not defined for the org,
16607: -- default to 1 (Locator and LPN Based Consolidation in Staging Lane)
16608: CURSOR c_default_operation_plan IS
16609: SELECT NVL(default_pick_op_plan_id, 1)
16610: FROM mtl_parameters
16611: WHERE organization_id = l_organization_id;
16612:
16613: l_rule_counter INTEGER;
16614: BEGIN
16856: 4, default_repl_task_type_id,
16857: 5, default_moxfer_task_type_id,
16858: 6, default_moissue_task_type_id,
16859: NULL)
16860: FROM mtl_parameters mp WHERE mp.organization_id = mmtt.organization_id)
16861: WHERE mmtt.standard_operation_id IS NULL
16862: AND mmtt.move_order_line_id IN (SELECT line_id
16863: FROM mtl_txn_request_lines mol
16864: WHERE mol.header_id = p_move_order_header_id);
16963: SELECT default_pick_task_type_id
16964: ,default_cc_task_type_id
16965: ,default_putaway_task_type_id
16966: ,default_repl_task_type_id
16967: FROM mtl_parameters
16968: WHERE organization_id = l_organization_id;
16969: */
16970:
16971: CURSOR c_default_task_type IS
16975: , default_repl_task_type_id
16976: , default_moxfer_task_type_id
16977: , default_moissue_task_type_id
16978: , default_pick_op_plan_id
16979: FROM mtl_parameters
16980: WHERE organization_id = l_organization_id;
16981:
16982: l_rule_counter INTEGER;
16983: BEGIN