APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_SYSTEM_ITEMS

Line 213: FROM mtl_system_items

209: IF (NOT g_item_routing_id_tb.EXISTS(p_item_id)) THEN
210: BEGIN
211: SELECT receiving_routing_id
212: INTO g_item_routing_id_tb(p_item_id)
213: FROM mtl_system_items
214: WHERE inventory_item_id = p_item_id
215: AND organization_id = p_organization_id;
216: EXCEPTION
217: WHEN NO_DATA_FOUND THEN

Line 2916: FROM mtl_system_items

2912: BEGIN
2913: SELECT primary_uom_code, NVL(reservable_type, 1),
2914: NVL(lot_control_code, 1), NVL(lot_divisible_flag, 'Y'), item_type
2915: INTO l_item_params_tb(l_inventory_item_id)
2916: FROM mtl_system_items
2917: WHERE inventory_item_id = l_inventory_item_id
2918: AND organization_id = l_organization_id;
2919: EXCEPTION
2920: WHEN OTHERS THEN

Line 6438: FROM mtl_txn_request_lines mtrl, mtl_system_items msi, wms_license_plate_numbers wlpn

6434: NVL(msi.reservable_type, 1) AS reservable_type,
6435: NVL(msi.lot_control_code, 1) AS lot_control_code,
6436: NVL(msi.lot_divisible_flag, 'Y') AS lot_divisible_flag,
6437: wlpn.lpn_context AS lpn_context
6438: FROM mtl_txn_request_lines mtrl, mtl_system_items msi, wms_license_plate_numbers wlpn
6439: WHERE mtrl.line_id = p_move_order_line_id
6440: AND mtrl.organization_id = l_organization_id
6441: -- Modified the line below to use an IN instead of <>
6442: -- AND mtrl.line_status <> inv_globals.g_to_status_closed