[Home] [Help]
170: ,mil.SUGGESTED_WEIGHT
171: ,mil.LOCATION_SUGGESTED_UNITS
172: ,mil.rowid
173: from MTL_ITEM_LOCATIONS mil
174: ,MTL_SECONDARY_INVENTORIES msei
175: where mil.organization_id(+) = msei.organization_id
176: and mil.subinventory_code(+) = msei.secondary_inventory_name
177: and NVL(msei.disable_date, sysdate+1) > sysdate
178: and NVL(mil.disable_date, sysdate+1) > sysdate
271: ,mil.SUGGESTED_WEIGHT
272: ,mil.LOCATION_SUGGESTED_UNITS
273: ,mil.rowid
274: from MTL_ITEM_LOCATIONS mil
275: ,MTL_SECONDARY_INVENTORIES msei
276: ,MTL_ITEM_SUB_INVENTORIES misi
277: where mil.organization_id(+) = msei.organization_id
278: and mil.organization_id=g_organization_id ---bug8425620 8665549
279: and mil.subinventory_code(+) = msei.secondary_inventory_name
376: ,mil.SUGGESTED_WEIGHT
377: ,mil.LOCATION_SUGGESTED_UNITS
378: ,mil.rowid
379: from MTL_ITEM_LOCATIONS mil
380: ,MTL_SECONDARY_INVENTORIES msei
381: ,MTL_ITEM_SUB_INVENTORIES misi
382: ,MTL_SECONDARY_LOCATORS msl
383: where mil.organization_id = msei.organization_id
384: and mil.organization_id=g_organization_id ---bug8425620 8665549
406: ,mil.INVENTORY_LOCATION_ID LOCATOR_ID
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
432: ,mil.INVENTORY_LOCATION_ID
433: ,mil.PROJECT_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
463: ,mil.PROJECT_ID
464: ,mil.TASK_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
519: ,NULL locator_inventory_item_id
520: ,NULL empty_flag
521: ,NULL location_current_units
522: from mtl_serial_numbers msn
523: ,mtl_secondary_inventories sub
524: ,mtl_item_locations loc
525: ,mtl_lot_numbers lot
526: where msn.current_status = 3
527: and decode(g_unit_number, ''-9999'', ''a'', ''-7777'', nvl(msn.end_item_unit_number, ''-7777''), msn.end_item_unit_number) =
575: ,NULL locator_inventory_item_id
576: ,NULL empty_flag
577: ,NULL location_current_units
578: from mtl_serial_numbers msn
579: ,mtl_secondary_inventories sub
580: ,mtl_item_locations loc
581: ,mtl_lot_numbers lot
582: where msn.current_status = 3
583: and decode(g_unit_number, ''-9999'', ''a'', ''-7777'', nvl(msn.end_item_unit_number, ''-7777''), msn.end_item_unit_number) =
631: ,NULL locator_inventory_item_id
632: ,NULL empty_flag
633: ,NULL location_current_units
634: from mtl_serial_numbers msn
635: ,mtl_secondary_inventories sub
636: ,mtl_item_locations loc
637: ,mtl_lot_numbers lot
638: where msn.current_status = 3
639: and decode(g_unit_number, ''-9999'', ''a'', ''-7777'', nvl(msn.end_item_unit_number, ''-7777''), msn.end_item_unit_number) =
730: ,mils.project_id, mils.task_id
731: HAVING
732: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
733: ) x
734: ,mtl_secondary_inventories sub
735: ,mtl_lot_numbers lot
736: where
737: -- x.primary_quantity > 0 and -- high volume project 8546026
738: x.organization_id = sub.organization_id
804: ,decode(mils.task_id, mils.task_id, moq.task_id)
805: HAVING
806: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
807: ) x
808: ,mtl_secondary_inventories sub
809: ,mtl_lot_numbers lot
810: where
811: -- x.primary_quantity > 0 and -- high volume project 8546026
812: x.organization_id = sub.organization_id
1598: || g_pick_base
1599: --extra line feed? || g_line_feed
1600: || ' ) x '
1601: || g_line_feed
1602: || ' ,mtl_secondary_inventories sub '
1603: || g_line_feed
1604: || ' ,mtl_item_locations loc '
1605: || g_line_feed
1606: || 'WHERE x.organization_id = loc.organization_id (+) '
4542: , p_to_subinventory_code IN VARCHAR2
4543: )
4544: RETURN VARCHAR2
4545: IS
4546: l_to_subinventory_code MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE := NULL ;
4547: l_transaction_action_id NUMBER := 0 ;
4548: l_debug NUMBER := g_debug ;
4549: l_api_name VARCHAR2(30) := 'chk_for_passing_xfer_sub';
4550: l_transaction_type_id NUMBER := 0 ;
8392: */
8393: retval := inv_cache.set_tosub_rec(g_locator.organization_id, g_locator.subinventory_code);
8394: /* select *
8395: into l_sub
8396: from mtl_secondary_inventories
8397: where secondary_inventory_name = l_locator.subinventory_code
8398: and organization_id = l_locator.organization_id;
8399: */
8400: success := INV_Validate.ValidateLocator(
14036:
14037: --cursor to get lpn controlled flag from subinventory
14038: CURSOR l_lpn_controlled IS
14039: SELECT lpn_controlled_flag
14040: FROM mtl_secondary_inventories
14041: WHERE organization_id = p_organization_id
14042: AND secondary_inventory_name = l_osubinventory_code;
14043:
14044:
14257: -- log_statement(l_api_name, 'p_organization_id :', p_organization_id);
14258: log_statement(l_api_name, 'To check dynamic loc : l_to_subinventory_code', l_to_subinventory_code);
14259:
14260: select locator_type into l_locator_type
14261: from mtl_secondary_inventories
14262: where organization_id = p_organization_id
14263: and SECONDARY_INVENTORY_NAME = l_to_subinventory_code;
14264:
14265: -- log_statement(l_api_name, 'l_locator_type' , l_locator_type);