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_PUTAWAY_UTILS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 88: TYPE item_tab IS TABLE OF MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE

84: TYPE sub_name_tab IS TABLE OF MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE
85: INDEX BY BINARY_INTEGER;
86: TYPE row_type_tab IS TABLE OF WMS_PUTAWAY_GROUP_TASKS_GTMP.ROW_TYPE%TYPE
87: INDEX BY BINARY_INTEGER;
88: TYPE item_tab IS TABLE OF MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE
89: INDEX BY BINARY_INTEGER;
90:
91:
92: TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 683: ,mtl_system_items_kfv msik

679: FROM mtl_material_transactions_temp mmtt
680: ,mtl_txn_request_lines mtrl
681: ,wms_dispatched_tasks wdt
682: --,mtl_item_locations milk
683: ,mtl_system_items_kfv msik
684: ,mtl_txn_request_headers mtrh
685: WHERE wdt.organization_id = p_organization_id
686: AND wdt.person_id = Decode(p_drop_type, g_dt_drop_all,p_emp_id,wdt.person_id)
687: AND wdt.status = 4

Line 2280: l_assembly MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

2276: l_operation_seq_num NUMBER;
2277: l_wip_entity_type NUMBER;
2278: l_start_date DATE;
2279: l_schedule WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;
2280: l_assembly MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
2281: l_wip_entity_id NUMBER;
2282:
2283: l_crossdock_type NUMBER;
2284: l_backorder_delivery_detail NUMBER;

Line 3410: ,mtl_system_items_kfv msik

3406: FROM mtl_material_transactions_temp mmtt
3407: ,mtl_txn_request_lines mtrl
3408: ,wms_dispatched_tasks wdt
3409: --,mtl_item_locations milk
3410: ,mtl_system_items_kfv msik
3411: ,mtl_txn_request_headers mtrh
3412: ,wms_license_plate_numbers wln
3413: --,mtl_secondary_inventories msi
3414: WHERE wdt.organization_id = p_org_id

Line 10275: , mtl_system_items_kfv msi

10271: , msi.primary_uom_code
10272: FROM mtl_material_transactions_temp mmtt
10273: , mtl_txn_request_lines mtrl
10274: , mtl_txn_request_headers mtrh
10275: , mtl_system_items_kfv msi
10276: , ( /*5723418*/
10277: SELECT wlpn.lpn_id
10278: FROM wms_license_plate_numbers wlpn
10279: START WITH wlpn.lpn_id = p_lpn_id