DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on MTL_SYSTEM_ITEMS

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 1659: l_assembly MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1655: l_operation_seq_num NUMBER;
1656: l_wip_entity_type NUMBER;
1657: l_start_date DATE;
1658: l_schedule WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;
1659: l_assembly MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1660: l_wip_entity_id NUMBER;
1661:
1662: l_crossdock_type NUMBER;
1663: l_backorder_delivery_detail NUMBER;

Line 2765: ,mtl_system_items_kfv msik

2761: FROM mtl_material_transactions_temp mmtt
2762: ,mtl_txn_request_lines mtrl
2763: ,wms_dispatched_tasks wdt
2764: --,mtl_item_locations milk
2765: ,mtl_system_items_kfv msik
2766: ,mtl_txn_request_headers mtrh
2767: ,wms_license_plate_numbers wln
2768: --,mtl_secondary_inventories msi
2769: WHERE wdt.organization_id = p_org_id

Line 7941: wms_lpn_contents wlpnc, mtl_system_items msi

7937: ,wlpnc.uom_code
7938: ,msi.serial_number_control_code
7939: ,msi.primary_uom_code
7940: FROM
7941: wms_lpn_contents wlpnc, mtl_system_items msi
7942: WHERE
7943: wlpnc.parent_lpn_id = p_from_lpn_id
7944: AND wlpnc.inventory_item_id = msi.inventory_item_id
7945: AND wlpnc.organization_id = msi.organization_id;

Line 9403: , mtl_system_items_kfv msi

9399: , msi.primary_uom_code
9400: FROM mtl_material_transactions_temp mmtt
9401: , mtl_txn_request_lines mtrl
9402: , mtl_txn_request_headers mtrh
9403: , mtl_system_items_kfv msi
9404: , ( /*5723418*/
9405: SELECT wlpn.lpn_id
9406: FROM wms_license_plate_numbers wlpn
9407: START WITH wlpn.lpn_id = p_lpn_id