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 173: from MTL_ITEM_LOCATIONS mil

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

Line 274: from MTL_ITEM_LOCATIONS mil

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

Line 379: from MTL_ITEM_LOCATIONS mil

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

Line 409: from MTL_ITEM_LOCATIONS mil

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

Line 435: from MTL_ITEM_LOCATIONS mil

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

Line 465: from MTL_ITEM_LOCATIONS mil

461: ,misi.SECONDARY_INVENTORY
462: ,msl.SECONDARY_LOCATOR
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

Line 524: ,mtl_item_locations loc

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

Line 580: ,mtl_item_locations loc

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

Line 636: ,mtl_item_locations loc

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

Line 704: , mtl_item_locations mils

700: ,mils.project_id project_id
701: ,mils.task_id task_id
702: FROM
703: mtl_onhand_quantities_detail moq
704: , mtl_item_locations mils
705: WHERE
706: moq.organization_id = g_organization_id
707: AND moq.inventory_item_id = g_inventory_item_id
708: AND moq.organization_id = mils.organization_id

Line 789: mtl_onhand_quantities_detail moq,mtl_item_locations mils

785: ,moq.lpn_id lpn_id
786: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
787: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
788: FROM
789: mtl_onhand_quantities_detail moq,mtl_item_locations mils
790: WHERE
791: moq.organization_id = g_organization_id
792: AND moq.inventory_item_id = g_inventory_item_id
793: AND moq.organization_id = mils.organization_id (+)

Line 1604: || ' ,mtl_item_locations loc '

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

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

2191: )
2192: ,0)
2193: ,NULL consist_string
2194: ,NULL order_by_string';
2195: g_rule_from := ' mtl_item_locations mil , ';
2196: g_rule_where := ' and mil.ORGANIZATION_ID (+) = base.ORGANIZATION_ID
2197: and mil.INVENTORY_LOCATION_ID (+) = base.locator_id ';
2198: END IF;
2199:

Line 8356: FROM mtl_item_locations

8352: -- return TRUE. If the locator has a project and task that is not equal
8353: -- to the required then return FALSE.
8354: /*SELECT *
8355: INTO l_locator
8356: FROM mtl_item_locations
8357: WHERE inventory_location_id = p_locator_id; Commented bug3237702*/
8358: -- Cache for better performance
8359: if nvl(g_locator_id,-9999) <> p_locator_id THEN
8360: SELECT *

Line 8362: FROM MTL_ITEM_LOCATIONS

8358: -- Cache for better performance
8359: if nvl(g_locator_id,-9999) <> p_locator_id THEN
8360: SELECT *
8361: INTO g_locator
8362: FROM MTL_ITEM_LOCATIONS
8363: WHERE inventory_location_id = p_locator_id;
8364: end if;
8365: --Added bug3237702 ends
8366:

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

12506: -- Case 1) Project and Task not supplied do nothing
12507: -- 2) Project and Task Supplied and current record has same
12508: -- project and task continue processing.
12509: -- 3) Project and Task supplied, not in current record
12510: -- then create a new entry in MTL_ITEM_LOCATIONS with
12511: -- properties of current record but with require project and task
12512: --
12513: IF p_project_id IS NOT NULL THEN
12514: IF NVL(l_oproject_id, -9999) <> p_project_id

Line 13727: FROM mtl_item_locations

13723: AND default_type = 3; -- default transfer order sub
13724:
13725: CURSOR l_locator_status_csr IS
13726: SELECT status_id
13727: FROM mtl_item_locations
13728: WHERE inventory_location_id = l_putaway_loc
13729: AND organization_id = l_organization_id ;
13730: --
13731: CURSOR l_locator_csr IS

Line 13734: mtl_item_locations mil

13730: --
13731: CURSOR l_locator_csr IS
13732: SELECT locator_id
13733: FROM mtl_item_loc_defaults mtld,
13734: mtl_item_locations mil
13735: WHERE mtld.locator_id = mil.inventory_location_id
13736: AND mtld.organization_id = mil.organization_id
13737: AND mtld.inventory_item_id = l_inventory_item_id
13738: AND mtld.organization_id = l_organization_id

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

14281: -- Case 1) Project and Task not supplied do nothing
14282: -- 2) Project and Task Supplied and current record has same
14283: -- project and task continue processing.
14284: -- 3) Project and Task supplied, not in current record
14285: -- then create a new entry in MTL_ITEM_LOCATIONS with
14286: -- properties of current record but with require project and task
14287: --
14288: IF p_project_id IS NOT NULL THEN
14289: