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_ITEM_LOCATIONS

Line 156: from MTL_ITEM_LOCATIONS mil

152: ,mil.SUGGESTED_CUBIC_AREA
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

Line 256: from MTL_ITEM_LOCATIONS mil

252: ,mil.SUGGESTED_CUBIC_AREA
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

Line 360: from MTL_ITEM_LOCATIONS mil

356: ,mil.SUGGESTED_CUBIC_AREA
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

Line 389: from MTL_ITEM_LOCATIONS mil

385: ,msei.SECONDARY_INVENTORY_NAME SUBINVENTORY_CODE
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

Line 415: from MTL_ITEM_LOCATIONS mil

411: ,misi.SECONDARY_INVENTORY
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

Line 445: from MTL_ITEM_LOCATIONS mil

441: ,misi.SECONDARY_INVENTORY
442: ,msl.SECONDARY_LOCATOR
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

Line 504: ,mtl_item_locations loc

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) =
508: decode(g_unit_number, ''-9999'', ''a'', g_unit_number)

Line 560: ,mtl_item_locations loc

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) =
564: decode(g_unit_number, ''-9999'', ''a'', g_unit_number)

Line 616: ,mtl_item_locations loc

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) =
620: decode(g_unit_number, ''-9999'', ''a'', g_unit_number)

Line 684: , mtl_item_locations mils

680: ,mils.project_id project_id
681: ,mils.task_id task_id
682: FROM
683: mtl_onhand_quantities_detail moq
684: , mtl_item_locations mils
685: WHERE
686: moq.organization_id = g_organization_id
687: AND moq.inventory_item_id = g_inventory_item_id
688: AND moq.organization_id = mils.organization_id

Line 764: mtl_onhand_quantities_detail moq,mtl_item_locations mils

760: ,moq.lpn_id lpn_id
761: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
762: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
763: FROM
764: mtl_onhand_quantities_detail moq,mtl_item_locations mils
765: WHERE
766: moq.organization_id = g_organization_id
767: AND moq.inventory_item_id = g_inventory_item_id
768: AND moq.organization_id = mils.organization_id (+)

Line 1521: || ' ,mtl_item_locations loc '

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 (+) '
1524: || g_line_feed
1525: || ' AND x.locator_id = loc.inventory_location_id (+)'

Line 2106: g_rule_from := ' mtl_item_locations mil , ';

2102: )
2103: ,0)
2104: ,NULL consist_string
2105: ,NULL order_by_string';
2106: g_rule_from := ' mtl_item_locations mil , ';
2107: g_rule_where := ' and mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
2108: and mil.INVENTORY_LOCATION_ID (+) = base.locator_id ';
2109: END IF;
2110:

Line 6393: FROM mtl_item_locations

6389: -- return TRUE. If the locator has a project and task that is not equal
6390: -- to the required then return FALSE.
6391: /*SELECT *
6392: INTO l_locator
6393: FROM mtl_item_locations
6394: WHERE inventory_location_id = p_locator_id; Commented bug3237702*/
6395: -- Cache for better performance
6396: if nvl(g_locator_id,-9999) <> p_locator_id THEN
6397: SELECT *

Line 6399: FROM MTL_ITEM_LOCATIONS

6395: -- Cache for better performance
6396: if nvl(g_locator_id,-9999) <> p_locator_id THEN
6397: SELECT *
6398: INTO g_locator
6399: FROM MTL_ITEM_LOCATIONS
6400: WHERE inventory_location_id = p_locator_id;
6401: end if;
6402: --Added bug3237702 ends
6403:

Line 10028: -- then create a new entry in MTL_ITEM_LOCATIONS with

10024: -- Case 1) Project and Task not supplied do nothing
10025: -- 2) Project and Task Supplied and current record has same
10026: -- project and task continue processing.
10027: -- 3) Project and Task supplied, not in current record
10028: -- then create a new entry in MTL_ITEM_LOCATIONS with
10029: -- properties of current record but with require project and task
10030: --
10031: IF p_project_id IS NOT NULL THEN
10032: IF NVL(l_oproject_id, -9999) <> p_project_id

Line 11144: FROM mtl_item_locations

11140: AND default_type = 3; -- default transfer order sub
11141:
11142: CURSOR l_locator_status_csr IS
11143: SELECT status_id
11144: FROM mtl_item_locations
11145: WHERE inventory_location_id = l_putaway_loc
11146: AND organization_id = l_organization_id ;
11147: --
11148: CURSOR l_locator_csr IS

Line 11151: mtl_item_locations mil

11147: --
11148: CURSOR l_locator_csr IS
11149: SELECT locator_id
11150: FROM mtl_item_loc_defaults mtld,
11151: mtl_item_locations mil
11152: WHERE mtld.locator_id = mil.inventory_location_id
11153: AND mtld.organization_id = mil.organization_id
11154: AND mtld.inventory_item_id = l_inventory_item_id
11155: AND mtld.organization_id = l_organization_id

Line 11693: -- then create a new entry in MTL_ITEM_LOCATIONS with

11689: -- Case 1) Project and Task not supplied do nothing
11690: -- 2) Project and Task Supplied and current record has same
11691: -- project and task continue processing.
11692: -- 3) Project and Task supplied, not in current record
11693: -- then create a new entry in MTL_ITEM_LOCATIONS with
11694: -- properties of current record but with require project and task
11695: --
11696: IF p_project_id IS NOT NULL THEN
11697: