[Home] [Help]
153: ,mil.SUGGESTED_WEIGHT
154: ,mil.LOCATION_SUGGESTED_UNITS
155: ,mil.rowid
156: from MTL_ITEM_LOCATIONS mil
157: ,MTL_SECONDARY_INVENTORIES msei
158: where mil.organization_id(+) = msei.organization_id
159: and mil.subinventory_code(+) = msei.secondary_inventory_name
160: and NVL(msei.disable_date, sysdate+1) > sysdate
161: and NVL(mil.disable_date, sysdate+1) > sysdate
253: ,mil.SUGGESTED_WEIGHT
254: ,mil.LOCATION_SUGGESTED_UNITS
255: ,mil.rowid
256: from MTL_ITEM_LOCATIONS mil
257: ,MTL_SECONDARY_INVENTORIES msei
258: ,MTL_ITEM_SUB_INVENTORIES misi
259: where mil.organization_id(+) = msei.organization_id
260: and mil.subinventory_code(+) = msei.secondary_inventory_name
261: and NVL(msei.disable_date, sysdate+1) > sysdate
357: ,mil.SUGGESTED_WEIGHT
358: ,mil.LOCATION_SUGGESTED_UNITS
359: ,mil.rowid
360: from MTL_ITEM_LOCATIONS mil
361: ,MTL_SECONDARY_INVENTORIES msei
362: ,MTL_ITEM_SUB_INVENTORIES misi
363: ,MTL_SECONDARY_LOCATORS msl
364: where mil.organization_id = msei.organization_id
365: and mil.subinventory_code = msei.secondary_inventory_name
386: ,mil.INVENTORY_LOCATION_ID LOCATOR_ID
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
412: ,mil.INVENTORY_LOCATION_ID
413: ,mil.PROJECT_ID
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
443: ,mil.PROJECT_ID
444: ,mil.TASK_ID
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
499: ,NULL locator_inventory_item_id
500: ,NULL empty_flag
501: ,NULL location_current_units
502: from mtl_serial_numbers msn
503: ,mtl_secondary_inventories sub
504: ,mtl_item_locations loc
505: ,mtl_lot_numbers lot
506: where msn.current_status = 3
507: and decode(g_unit_number, ''-9999'', ''a'', ''-7777'', nvl(msn.end_item_unit_number, ''-7777''), msn.end_item_unit_number) =
555: ,NULL locator_inventory_item_id
556: ,NULL empty_flag
557: ,NULL location_current_units
558: from mtl_serial_numbers msn
559: ,mtl_secondary_inventories sub
560: ,mtl_item_locations loc
561: ,mtl_lot_numbers lot
562: where msn.current_status = 3
563: and decode(g_unit_number, ''-9999'', ''a'', ''-7777'', nvl(msn.end_item_unit_number, ''-7777''), msn.end_item_unit_number) =
611: ,NULL locator_inventory_item_id
612: ,NULL empty_flag
613: ,NULL location_current_units
614: from mtl_serial_numbers msn
615: ,mtl_secondary_inventories sub
616: ,mtl_item_locations loc
617: ,mtl_lot_numbers lot
618: where msn.current_status = 3
619: and decode(g_unit_number, ''-9999'', ''a'', ''-7777'', nvl(msn.end_item_unit_number, ''-7777''), msn.end_item_unit_number) =
706: ,moq.subinventory_code, moq.locator_id --added status_id
707: ,moq.cost_group_id,moq.status_id,mils.reservable_type,moq.lpn_id -- Bug 6719290
708: ,mils.project_id, mils.task_id
709: ) x
710: ,mtl_secondary_inventories sub
711: ,mtl_lot_numbers lot
712: where x.primary_quantity > 0
713: and x.organization_id = sub.organization_id
714: and x.subinventory_code = sub.secondary_inventory_name
775: ,moq.cost_group_id,moq.status_id, mils.reservable_type, moq.lpn_id -- Bug 6719290
776: ,decode(mils.project_id, mils.project_id, moq.project_id)
777: ,decode(mils.task_id, mils.task_id, moq.task_id)
778: ) x
779: ,mtl_secondary_inventories sub
780: ,mtl_lot_numbers lot
781: where x.primary_quantity > 0
782: and x.organization_id = sub.organization_id
783: and x.subinventory_code = sub.secondary_inventory_name
1515: || g_pick_base
1516: --extra line feed? || g_line_feed
1517: || ' ) x '
1518: || g_line_feed
1519: || ' ,mtl_secondary_inventories sub '
1520: || g_line_feed
1521: || ' ,mtl_item_locations loc '
1522: || g_line_feed
1523: || 'WHERE x.organization_id = loc.organization_id (+) '
4189: , p_to_subinventory_code IN VARCHAR2
4190: )
4191: RETURN VARCHAR2
4192: IS
4193: l_to_subinventory_code MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE := NULL ;
4194: l_transaction_action_id NUMBER := 0 ;
4195: l_debug NUMBER := g_debug ;
4196: l_api_name VARCHAR2(30) := 'chk_for_passing_xfer_sub';
4197: l_transaction_type_id NUMBER := 0 ;
6429: */
6430: retval := inv_cache.set_tosub_rec(g_locator.organization_id, g_locator.subinventory_code);
6431: /* select *
6432: into l_sub
6433: from mtl_secondary_inventories
6434: where secondary_inventory_name = l_locator.subinventory_code
6435: and organization_id = l_locator.organization_id;
6436: */
6437: success := INV_Validate.ValidateLocator(
6755:
6756: --cursor to get lpn controlled flag from subinventory
6757: CURSOR c_subinventory IS
6758: SELECT lpn_controlled_flag, reservable_type
6759: FROM mtl_secondary_inventories
6760: WHERE organization_id = p_organization_id
6761: AND secondary_inventory_name = l_osubinventory_code;
6762:
6763: --cursor to get the total quantity for the LPN
11452:
11453: --cursor to get lpn controlled flag from subinventory
11454: CURSOR l_lpn_controlled IS
11455: SELECT lpn_controlled_flag
11456: FROM mtl_secondary_inventories
11457: WHERE organization_id = p_organization_id
11458: AND secondary_inventory_name = l_osubinventory_code;
11459:
11460:
11665: -- log_statement(l_api_name, 'p_organization_id :', p_organization_id);
11666: log_statement(l_api_name, 'To check dynamic loc : l_to_subinventory_code', l_to_subinventory_code);
11667:
11668: select locator_type into l_locator_type
11669: from mtl_secondary_inventories
11670: where organization_id = p_organization_id
11671: and SECONDARY_INVENTORY_NAME = l_to_subinventory_code;
11672:
11673: -- log_statement(l_api_name, 'l_locator_type' , l_locator_type);
15894:
15895: --cursor to get lpn controlled flag from subinventory
15896: CURSOR c_subinventory IS
15897: SELECT lpn_controlled_flag, reservable_type
15898: FROM mtl_secondary_inventories
15899: WHERE organization_id = p_organization_id
15900: AND secondary_inventory_name = l_osubinventory_code;
15901:
15902: --cursor to get the total quantity for the LPN